transfer spreadsheet-create a date

[Guest]

I am using 2003. I use transferspreadsheet to send many (10) access tables
to excel files. I run this once a week and manually type in the current date
for each transfer, the rest of the name remains the same. Is possible to
include a date function in the file name so that it includes the current date
in the file name in excel? For example
transfer type: export
Spreadsheet type: microsoft excel8-10
table name:testfile
file name:J:\top30\testfile-9-26-07.xls
has field names:yes
I would like to be able to change the date 9-26-07 automatically and avoid
typing a new date for all the transfer actions.
Is this possible? Any help will be much appreciated.

 

[Ken Snell \(MVP\)]

Use an expression in the File Name argument of the TransferSpreadsheet
action:

="J:\top30\testfile-" & Format(Date(),"m-d-yy") & ".xls"

 

[Guest]

Ken,
Your answer was great! Thank you so much!

Use an expression in the File Name argument of the TransferSpreadsheet
action:

="J:\top30\testfile-" & Format(Date(),"m-d-yy") & ".xls"