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

  • Thread starter Thread starter AlanN
  • Start date Start date
A

AlanN

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

Thanks, Alan
 
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 **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates in Excel 2003 1
Date & Time Format 7
time in subject line 1
Date Stamp with protection 6
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Date format changing in csv file 6
date format changes when I save to CSV via a macro, but not manual 4
When subtracting dates issue 11

Back
Top