Thread: Have current date display in File Name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
darrenmcconachie darrenmcconachie is offline
external usenet poster
  
Posts: 6
Default Have current date display in File Name
Is this what you're after...

ActiveWorkbook.SaveAs Filename:= _
"C:\Payable\" & Format(Now, "MM-DD-YYYY") & " Payable.xls", _
FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Regards
Darren

Reply With QuoteReply With Quote