View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Allen Ben Allen is offline
external usenet poster
 
Posts: 21
Default 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!"