| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save date in filename
Hi. I would like to have the current date saved in the
filename when the macro is excercised. For instance, the filename is "Log File.xls". I would like a command that, if executed on February 23, it would save the filename "Log File - 2/23/04.xls. My current command is: ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\Archive\" & "Log File" What should I add to this command to include the date? Thanks, Mike. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| Save as .htm with filename from cell | Excel Discussion (Misc queries) | |||
| Disabling Macros After A Save To A Different Filename | Excel Programming | |||
| Save Filename+Date+Time? | Excel Programming | |||
Threaded Mode
