Hi all! I have this Macro, currently working fine, just fine:
What this does currently (if you can'y already tell) is takes each sheet and makes it it's own workbook, then saves as the sheet name in a certain folder, then sends it in an email.
My boss has asked me to add another step. I need to show only the first five sheets ("Maloney", "Petralia", "Borek", "Leach", "Petrosino") and hide everything else. Then I need to make a copy, save it as "Horne" in the same folder, and send in an email (same steps as above). I thought I did it right, but it is saving the current workbook as Horne, and that can't happen, because I need an additional step after this where I show only six other sheets and save it as "Marose" ("Armenis", "Greene", "Padilla", "Meadors", "Gagne", "Dargusch").
This is the code I attempted the first additional step with:
Please... HELP!
Bookmarks