Using TransferSpreadsheet

[Keith S]

Is there a way in a macro on the File Name during an export of the
TransferSpreadsheet function to add today's date at the end of the file name.
In other words, I want my file to be:

File Name P:\Reports\Daily Service Report_2/1/08.xls

I hope this explains it properly. Thanks for any help.

 

[Steve Schapel]

Keith,

Yes, like this:

="P:\Reports\Daily Service Report_" & Format(Date(),"m/d/yy" & ".xls"