Export Data To XLS With Current Date?

[Seikyo]

Is it possible for the file that need to export have an add-on date at the
end? This allow user to know what is the date they last export in the
computer.

TimeCard 1303-

 

[Douglas J. Steele]

Create a query that includes the Date function (or the Now function) as a
computed field. Export the query, not the table.

 

[Seikyo]

I think I change my way of backup files. I use another database instead and
use an append query to add timecard over the backup database and clear the
present database for new input.

 

[Ken Snell [MVP]]

You can put the date in the filename of the EXCEL file by using an
expression in the Filename argument of the TransferSpreadsheet action -- for
example:

"C:\MyFolder\MyFilename" & Format(Date(), "yyyymmdd") & ".xls"