save with a macro

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)?
 
P

pfsardella

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
 
Top