Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving with date in filename
I have this code:
ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\Ben Allen\My Documents\Eurotours\Eurotours.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Is there a wat to make it say the current month and year after the Eurotours bit in the name? Thanks -- Cheers, Ben Remove your.tonsils to reply "You only live once but if you do it right once is enough!" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving file using value in cell as the filename | Excel Worksheet Functions | |||
Saving XLS workbook with set filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Saving filename same as import filename | Excel Programming | |||
Saving Cell value as filename | Excel Programming |