How not to delete/overlay a saved spreadsheet.

[cassidybklyn]

Hello everyone.
I generated an excel spreadsheet from vb and saved it to my local drive, but I want to append today's date and time to the file:
example:

xlWbk.SaveAs("myspreadsheet_05/09/2007_00:00:00.xls")

The next time I generate this same spreadsheet, I do not want to overlay the previous one; I want to save it also, and so on......

What vb6 code can I use to get this done.
Thanks.
C.

 

[JerryKlmns]

xlWbk.SaveAs "c:\myspreadsheet_" & Format (Now(), "yyyy-mm-dd_hhnnss") & ".xls"

You cant use these characters in filenames \ / : * ? < > | '

 

[Loomah]

how about
xlWbk.SaveAs("myspreadsheet_"&Format(Now(), "dd/mm/yy_hh:mm:ss"))

obviously change the format picture to suit!


;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Loomah]

just realised stupid error in what i said and now see that it was pointed out before my rely appeared!!

no / or : allowed!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[cassidybklyn]

Thanks guys. "Bone-head" me; I figured out that if I embed and format the date and time to the seconds, Like: & date & time, each time the file is saved, it will always be different.
Thnx y'all.
C.