I have a table (TBL-Today) that I need to copy within the same database with a different name (usually TBL-yymmdd). I usually just copy and paste it and give it the new name. I want to make a macro that will copy and paste the table and automatically give it name based on todays date. If that can't be done, is there a way to have the macro prompt for the new name of the table?
Help Copying an Object with a Macro
- Thread starter SMatthews
- Start date
