Save as inside a Macro

[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

 

[Van T. Dinh]

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!)