Saving with date in filename
I have this code:
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Ben Allen\My
Documents\Eurotours\Eurotours.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Is there a wat to make it say the current month and year after the Eurotours
bit in the name?
Thanks
--
Cheers,
Ben
Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"
|