Adding Today's Date to an Excel Filename using TransferSpreadsheet

N

Nick M

Hello All,
I run a weekly query using access and I export the resulting table (Co-Sync)
into a folder using TransferSpreadsheet. I would like the table to be named
with the date of the export. i.e: Co-Sync-03-15-2007.
Is there a way to do this using macros? I'm clueless when it comes to VB but
I'll learn if need be.
Thank you for your time!
Regards
-N
 
S

storrboy

Use this syntax as the filename for the macro.

="[path]\SpreadSeetName-" & Format(Date(),"mm-dd-yyyy")

example

="C:\My Documents\Co-Sync-" & Format(Date(),"mm-dd-yyyy")
 

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
Export filename includes Date 5
Output the "Created Time/Date" to an Excel file 2
Export Query to Excel 97 using TransferSpreadsheet 2
Export to Excel - Date in Filename 5
Exporting tables to Excel 13
Inserting today's date using JavaScript 2
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1

Top