> (Q1):
Look at...
support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q180/7/36.asp&NoWebContent=1

> (Q2):
You simply cannot use those characters in the name. Try a dash "-"...
20-07-2007, or a short text date  like.... Mon 12th July

> Main puspose: I needed  to save  the worksheets  everyday on the
> same workbook.
You are going to have a LOT of worksheets and it's very likely that you
won't see the date anyway!
Try splitting the workbooks up into week numbers... 7 or 5 sheets per
workbook, with links to each in a main worksheet  or web page.

"Try splitting the workbooks up into week numbers... 7 or 5 sheets
perworkbook, with links to each in a main worksheet  or web page."

I have the same idea with you,but i don't how to link the workbook to
worksbook. if link between worksheet then i know a bit. Can you
please give me some idea?pls advice.

You wouldn't actually link a workbook. Set a hyperlink to a sheet in the
workbook.... Probably the first one.

First you'd build the 50 od sheets for each week... Could be 12 for each
month maybe... I'd try both and see which one I / my users prefered.
Then start up another workbook and Insert / Hyperlink ... and point to the
first sheet in the workbook.

So for example... I'd have my new workbook open and then open week ones
workbook. Then Insert / Hyperlink into my new sheet and point to say A1 of
Sunday.

OTOH... You could have a list of the workbooks in a range, select one and
click a button to open it.

on question 1 yes you can but the form and update  will be very time  intensive
and probably should not be done at least on a second by second basis.. minutes
ok shouldn't hurt time as much...

on question 2.. you would use the format function like this

worksheet.name = format(date(now), "mm-dd-yy") that would name the worksheet  as
12-10-07....

By the ways can you provide me some code
regarding the Q1.?

Complie error  on the "worksheets.name = format(date(now), "mm-dd-
yy")

worksheets(number).name = format(date(now), "mm-dd-yy") replace the (number)
with either the sheet number in the book or the current name of the sheet i.e.
worksheet(1) or worksheets("sheet2") etc for the first one.. if there is only
one sheet in the book then its 1 if there is more than one.. it would be a
little harder to figure out.. i'd stay with the "Sheet1" version