Export a Table and rename the file

  • Thread starter Thread starter Christhomas1974
  • Start date Start date
C

Christhomas1974

I have a table in My Database which is a list of discounts offered by a
supplier.

This Table needs to be updated when the supplier offers a new discount.

I wan to tbe able to export this table by using a macro connected to a
button in a form.

But I don't want it to overwrite the previous file every time it exports
just incase it's done incorrectly by the end user.

Does anyone have any suggestions how this can be best achieved?
 
How are you exporting the table? TransferText? TransferSpreadsheet?

Either way, use an expression in the File Name argument of the macro action
(using EXCEL file type as example):

="C:\MyFolder\MyFilename" & Format(Date(), "mmddyyyy") & ".xls"
 
Back
Top