I would like a macro to create a new folder in a new Directory...as well as save multiple sheets from the same book individually.... in the same Folder.
I do not have a macro to create a new folder in an existing path. Below are the appropriate saving info of the macros I am currently using.
The Destination of the new folder And Range of the new name of the folder.
Here are the sheets and the code whereby i save each one individuallyPlease Login or Register to view this content.
This Saves sheet (6 Estimate Print)
This saves 2 sheets (Stocked Items", "Stocked Prices)Please Login or Register to view this content.
This Saves Sheet (Terrance Labor Tracker)Please Login or Register to view this content.
This saves sheet (Contract Job Tracker)Please Login or Register to view this content.
How do I get all these in one Macro and saved into a new folder, new location with a new name.Please Login or Register to view this content.
Bookmarks