Save as inside a Macro

  • Thread starter Thread starter tiffany
  • Start date Start date
T

tiffany

How can I set up a macro to copy an exsisting table and
then prompt me to name it or assign it the same name with
an addition of the current date??

any suggestions are appreciated
 
Macro action: CopyObject
Arguments:
* Destination Database: (blank)
* Source Object Type: Table
* Source Object Name: YourTable
* New Name: = "YourTable_" & Format(Date(), "dd/mm/yyyy")

(including the equal sign!)
 
Back
Top