Using TransferSpreadsheet

K

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.
 
S

Steve Schapel

Keith,

Yes, like this:

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