How can I use the Rename macro action to not overwrite the file

[Mel]

I need to create a macro that copies a table and exports it but also saves
the table as a new table name each time the macro runs. Bascially, I need to
be able to maintain the historical tables.

 

[Ken Snell [MVP]]

Use the TransferText (if you want a text file as the output). In the File
Name argument, use an expression such as this to incorporate the date and
time in the name to make it unique:

="C:\MyFolder\MyFileName" & Format(Now(), "yyyymmdd_hhnnss") & ".txt"

 

[Steve Schapel]

Mel,

Maybe the CopyObject macro is what you need.