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"
 
Back
Top