Rogerant79
New Member
- Joined
- Oct 14, 2020
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
Is there a way to copy some sheets from an excel file to a new file to create?
I have an .xlsm file with VBA macros.
I would like to save only some sheets of this file in another file that does not have any vba macros (so a simple file with .xlsx extension).
In the source file (.xlsm) I have several sheets, 4 of which are visible and 6 others are hidden (very hidden).
So I would like to copy only the 4 visible sheets of the source file, in a new file with the extension .xlsx.
Also I would like the new file created during the whole process not to be opened.
Can anyone help me out?
Thanks
I have an .xlsm file with VBA macros.
I would like to save only some sheets of this file in another file that does not have any vba macros (so a simple file with .xlsx extension).
In the source file (.xlsm) I have several sheets, 4 of which are visible and 6 others are hidden (very hidden).
So I would like to copy only the 4 visible sheets of the source file, in a new file with the extension .xlsx.
Also I would like the new file created during the whole process not to be opened.
Can anyone help me out?
Thanks