Export in Excel with dateformat

[scgoodman]

I would like to export a table to excel with a default today's date at the end of the filename. Can someone help me, please?

 

[ted.martin]

try this:

DoCmd.OutputTo acOutputTable, "myTable", "ExcelWorkbook(*.xlsx)", _
"c:\temp\myTable_" & Format(Date, "ddmmyy") & ".xlsx", False, "", 0, acExportQualityPrint