Export Data To XLS With Current Date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-
 
Create a query that includes the Date function (or the Now function) as a
computed field. Export the query, not the table.
 
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.
 
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"
 
Back
Top