Output to macro

Q

quixote

Is there anyway to concatenate the Date to a filename
using Output To macro. For example I am outputting a table
to excel. I would like to save the file to a network
directory and give the date as part of the file name.

myFile08-19-03.xls...or myfile081903.xls

I would like to automate this rather than propmting the
user to Save As.

Thanks
 
S

Steve Schapel

Quixote,

In case your'e interested in a simplification...
DoCmd.OutputTo acTable, "myTable", "MicrosoftExcel(*.xls)",
"G:\Test\TestFile" & Format(Date,"yymmdd") & ".xls", False

By the way, this is not a macro, it is a VBA procedure.

- Steve Schapel, Microsoft Access MVP
 

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

Need to export multiple files 3
Output to macro action 1
Using Output To Macro and wants to automatically "Save As" 4
Output File Naming 10
VBA word change keys 0
Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
How to Create Multiple Sheets in an Output File 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top