Copy/Paste sheets from one WS-A to another WS-B with some sheets hidden

[sha2shoo2]

L&G,

I'm new to the world of VBA & Macros. I tried self-learning by searching online for and applying the codes to my current sheets.
What I need to do now on my current project (I have looked and unfortunately failed) is:

1- Copy the entire sheets in Workbook A (xlsm file).
2- Sheet names in Workbook A are unconventional (i.e: full routine, training calendar, results, etc...).
3- Paste those copied sheets exactly with their entire content into a new Workbook B (xslm file).
4- Have certain sheets hidden in the new Workbook B (not deleted, i.e: training calendar).
5- The code should only be applied when you click a button in Workbook A (i.e: Export File) and should be placed in the first sheet of Workbook A.
6- Once this button is clicked, it would allow the user to save the new Workbook B in any destination on his computer.

I really would appreciate it if anyone can help me as this had me going crazy.

Thanks
Sha2shoo2

[sha2shoo2]

Hey,

I really would appreciate it if anyone can help me with this.


Thanks
Sha2shoo2

[maniacb]

It would help us to help you if you could upload a sample file, as per the yellow banner above. Just replace your data with x's so we can see your file structure.

[sha2shoo2]

I have added a sample worksheet as a reference.

Thanks
Sha2shoo2

[sha2shoo2]

maniacb, i just added a sample below as requested.

Thanks
Sha2shoo2

[maniacb]

Here is the code that should meet your requirements. It is not in the same order of events that you highlighted but it achieves the same result. This approach hides the necessary sheet, saves the original file with a new name - date added, then reopens the original file name. Let us know how it goes. You then have both the new file and the original file open. See code to activate closing new file if that is what you wish.

Please Login or Register  to view this content.

[sha2shoo2]

Maniacb, thank you so much for your assistance.
The code worked like a charm, I really appreciate your help.

Regards
Sha2shoo2