rickyguzman
New Member
- Joined
- Mar 22, 2023
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
So there seems to be a limitation with Excel that if I have tables, I can not copy worksheets at the same time that contains tables.
What I am trying to do with a macro is to move two sheets to a new workbook. the problem is that if I move them one a at time, Excel will name the active workbook as Book1, Book2, etc...and the next time the Macro runs, it will give an error because is trying to find the old book1, book2....
I am able to save as first and then I can reference the open workbook, however because I am in a work network, I am not able to save to the same path for everyone (i.e. User/XXXX?Desktop)
Is there any way I can copy one at a time but forcing the new active workbook with always have the same name?
What I am trying to do with a macro is to move two sheets to a new workbook. the problem is that if I move them one a at time, Excel will name the active workbook as Book1, Book2, etc...and the next time the Macro runs, it will give an error because is trying to find the old book1, book2....
I am able to save as first and then I can reference the open workbook, however because I am in a work network, I am not able to save to the same path for everyone (i.e. User/XXXX?Desktop)
Is there any way I can copy one at a time but forcing the new active workbook with always have the same name?