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

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

Guest

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.
 
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"
 
Back
Top