Save a report automatically with date appended to file name

  • Thread starter Thread starter Bryan Haas
  • Start date Start date
B

Bryan Haas

Is there a way to output a report using a macro and have
the file name be modified to include the current date?
(i.e. instead of report.xls have it read report071904.xls
or something along those lines)

Thank you!
Bryan
 
I have recently used the Transfer Text DoCmd attached to a
command button on a form. Below is that code. Perhaps
you can somehow fit it in a macro.

CI Export = export spec
qryExport = query


DoCmd.TransferText acExportDelim, "CI
Export", "qryExport","C:\ReportName_" & Format(Now
(), "mmddyy_hh_nnAM/PM") & ".txt"
 
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

copy data from one excel workbook to another workbook using macro 4
Exporting Reports with Today's Date 9
Open and Save Files in Directory 1
Adding date to outputted file name returning error. 4
Run report on the 5th of every month automatically 0
Save a report as .snp 1
Including field names in RTF Report filename 1
Displaying Last Date in Report Footer 2

Back
Top