Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Filename+Date+Time?
Is it possible to automatically, with macro or vb, save a currently open
file with the (filename+date+time) to create a new file? Example: File1.xls (currently open) File1mmddyyhhmmss.xls (newly created file) Thanks, Erwin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Filename+Date+Time?
Erwin,
Try ActiveWorkbook.SaveAs _ "FileName" & Format(Now,"mmddyyhhmmss") & ".xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Scooby912" wrote in message ... Is it possible to automatically, with macro or vb, save a currently open file with the (filename+date+time) to create a new file? Example: File1.xls (currently open) File1mmddyyhhmmss.xls (newly created file) Thanks, Erwin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save by & date, time | Excel Worksheet Functions | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
Save Date & Time | Excel Worksheet Functions | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Save as Current Date / Time | Excel Discussion (Misc queries) |