Current date in file name

  • Thread starter Thread starter ACNJim
  • Start date Start date
A

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.
 
Jim,

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

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