Add current date to file name when exporting to Excel

[Leanne]

Is there a way to programatically add the current date to a file name when
exporting a query, table, report via a macro?

 

[RonaldoOneNil]

As long as the date does not contain slashes as this would affect the file
path name.
Below is an example of the filename in a TransferSpreadsheet command in a
macro.

="C:\Temp\Test" & Format(Date(),"dd-mm-yyyy") & ".xls"

 

[Douglas J. Steele]

Use something like

"MyFile" & Format(Date, "yyyy\-mm\-dd") & ".txt"

instead of just

"MyFile.txt"