Export destination file names?

[Adam]

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?

 

[John Nurick]

Hi Adam,

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

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

 

[Adam]

thank you very much...

Hi Adam,

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

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