Saving Date in file name automatically

  • Thread starter Thread starter John
  • Start date Start date
J

John

I want to add the current date to a saved file automatically.

ActiveWorkbook.SaveAs Filename:= _
"C:\DailySummaryReportPFL(I want to add date automatically
here)", _
FileFormat:=xlText, CreateBackup:=False
 
John,

The focus of this newsgroup is macros in Access, the database product.
Sounds like your question relates to Excel, and you would have a better
chance of a good answer in an Excel newsgroup.
 
ActiveWorkbook.SaveAs Filename:= _
"C:\DailySummaryReportPFL " & year(date()) &
format(month(date()),"00") & format(day(date()),"00") ), _
FileFormat:=xlText, CreateBackup:=False
 
Back
Top