no you're not. the following are forbidden by excel as file nameing
convictions.......
: / \ * [ ]
make a note.
the slashes in the date are forbidden by dos becasue dos would interpet them
as switches and do weird thing or throw up errors.
instead of using the "date in a cell" method, use something like this in
your nameing code....
timestamp = Format(Month(Now), "00") & Format(Day(Now), "00") & _
Format(Year(Now), "0000") & "_" & Format(Hour(Now), "00") _
& ":" & Format(Minute(Now), "00")

or similar.

nice time to bring up..."oh! i forgot to mention......."

FSt1
geez

"sam" wrote:

Hey FSt1, I forgot to mention one thing.. I am going to save the file with
date and time stamp(from that cell). But I dont want the date and time value
to update with current date and time when I open any previous saved file.
Sorry for the confusion before

Hope I made it clear

THanks in advance

"FSt1" wrote:

hi
in any cell you wish, enter........
=now()

the cell will update each time the workbook is opened or the sheet is
calculated.
formula is volital meaning it don't stay the same for long.
if you just want the date without time..
=today()

regards
FSt1


regards
FSt1




"sam" wrote:

Hi All,

Is there a way I can display Current Date & Time in a cell which updates
everytime I open the workbook?

Thanks in Advance