Output to macro

  • Thread starter Thread starter quixote
  • Start date Start date
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
 
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
 
Back
Top