Export date in filename

G

Guest

Hi,

I am writing a macro at the moment - i want to output the results of a query
into an excel, with the date the macro was run, so the filename is
cancellations20051229.xls is there any way of doing this?

Thanks
 
K

Ken Snell [MVP]

Use this expression as the filename argument in the TransferSpreadsheet
action:

="C:\MyFolder\cancellations" & Format(Date(), "yyyymmdd") & ".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

Export table to txt file with a variable filename 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Current date in file name 1
Read only error when trying to export table using Macro 1
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Export a table to text file with file name depending on certain da 12
Need to export multiple files 3
Export to Excel with Parameter in Filename 1

Top