Current date in file name

[ACNJim]

I am using a macro to output the results of a query as an excel file. i would
the the current date when the macro is run to be in the file name. is this
possible? If not is it possible to have the current date in the name of the
query, then i can use the export option in my macro.

 

[Steve Schapel]

Jim,

In the Output File argument of your OutputTo macro action, something
along these lines:

="C:\YourFolder\Bla_" & Format(Date(),"yymmdd") & ".xls"