Create new excel file from existing Excel file.

Eric - May 24, 2016 at 04:06 PM
 Blocked Profile - May 24, 2016 at 06:30 PM
I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for where to save new file)
The existing file have 6 spreadsheets,
But in the newly created excel file I want to have only 4 spreadsheet copied completely from existing spreadsheet without altering the format.

I am new in excel macros any help will be very much appreciated.


1 response

Blocked Profile
May 24, 2016 at 06:30 PM
So, you only want four of the six TABS copied in the new file?

We really cannot complete tasks such as these turnkey, for these very reasons above. We will spend time (we are volunteers) and energy developing some solution, and they are never QUITE right, and they continue beyond the scope of the original project!

That doesn't mean that an Excel EXPERT won't come along because he likes to help, and he likes challenges even more! It does happen.

I can see an easy process: copy, paste, rename alter, Delete tabs in alter.

But that is me!