| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save file as todays date
I made a macro on the excel and at the end of the macro I save it on a new
file. Can I put the date when I save the file as part of the file name? Here is copy the last part of the macro: ActiveWorkbook.SaveAs Filename:= _ "O:\Shared Services\Finance\2009\IC\IC Detail\IST_3_1_Update_ddmmyyyy.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save file with todays date ref#11235 | Excel Worksheet Functions | |||
| Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
| Saveing workbook to a file as todays date daily | Excel Worksheet Functions | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
| Automatic Populate Todays Date in Cell when File is Saved. | Excel Discussion (Misc queries) | |||
Threaded Mode
