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

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

Back
Top