Macro help with saving a spreadsheet with date and time in it

A

AlanN

Can someone help me with some code that would save a file name as
"schedule-mm-dd-yyyy-hh:mm"?

Thanks, Alan
 
P

Paul B

Alan, how about something like this

Sub Save_As()
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Top