Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Friends,
The below portion of a macro saves a file with the current date as part of the file name in the format: Voyager 5-Oct.xls ActiveWorkbook.SaveAs Filename:= _ "H:\Reporting\Voyager " & Format(Date, "d-mmm") & _ ".xls" I want to modify the macro so it also saves the file with the current date and also the current time, in the something like the format: Voyager 5-Oct 12_08 pm.xls How would I do this? Thanks, Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding date for filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Filename with current Date() | Excel Programming | |||
Save Filename+Date+Time? | Excel Programming |