Filename with date and time

[Alan]

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

 

[Tom Ogilvy]

ActiveWorkbook.SaveAs Filename:= _
"H:\Reporting\Voyager " & Format(Date, "d-mmm") & _
format(time,"_hh AM/PM") & ".xls"

 

[Frank Kabel]

Hi
try
ActiveWorkbook.SaveAs Filename:= _
"H:\Reporting\Voyager " & Format(Now, "D-MMM hh_mm") & _
".xls"