save with a macro

  • Thread starter Thread starter mfrancom
  • Start date Start date
M

mfrancom

is it possible to build a macro in which it is possible to
save a a file with a fixed name and a variable date (today
date)?
 
Sub NameFile()

Const strFile as String = "FixedPart"

ActiveWorkbook.SavesAs Filename:= strFile & _
Format(Date,"mmddyyyy") & ".xls"

End Sub

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul
 

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

Pivot table macro filter data between yesterday and today (date+time) 0
Run macro after booting is over 2
Save File in Desired Location & Name 2
Help to create a macro 2
file save as 5
Excel Macro to automatically go to the right of the last colored cell 0
Excel 2003 save as .XLSX 10
pausing a "save as" macro 1

Back
Top