Export date in filename

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Use this expression as the filename argument in the TransferSpreadsheet
action:

="C:\MyFolder\cancellations" & Format(Date(), "yyyymmdd") & ".xls"
 
You must log in or register to reply here.

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
Export a table to text file with file name depending on certain da 12
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
OutputTo Macro 3
Read only error when trying to export table using Macro 1
Current date in file name 1
Exporting Multiple Queries to the same Excel File 4

Back
Top