Using TransferSpreadsheet

  • Thread starter Thread starter Keith S
  • Start date Start date
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.
 
Keith,

Yes, like this:

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