Saving Date in file name automatically

[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

 

[Steve Schapel]

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.

 

[Ron2006]

ActiveWorkbook.SaveAs Filename:= _
"C:\DailySummaryReportPFL " & year(date()) &
format(month(date()),"00") & format(day(date()),"00") ), _
FileFormat:=xlText, CreateBackup:=False