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
 
Back
Top