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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2007 TransferSpreadsheet Import 5
TransferSpreadsheet 2
Too many fields defined 1
Output File Naming 8
Import Excel or CSV File Using TransferSpreadsheet or TransferText 1
How to import 2 spreadsheet files with one file name entry 5
cannot expand named range 1
Output the "Created Time/Date" to an Excel file 2

Back
Top