Export a Table and rename the file

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?
 
K

Ken Snell [MVP]

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top