Export destination file names?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a macro for a transfer spreadsheet action, type export.
When setting the action arguments at the bottom, in the file name argument;
how can i set the file name arguement so that it uses todays date as part of
the file name?
 
Hi Adam,

You can use an expression like this for the file name:

="C:\Folder\XXX" & Format(Date(),"yyyymmmdd") & ".xls"
 
Back
Top