| 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) | |||
Linear Mode
