Macro that creates a new folder, File, pdf in a new location

[TBM]

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.

Please Login or Register  to view this content.

Here are the sheets and the code whereby i save each one individually

This Saves sheet (6 Estimate Print)

Please Login or Register  to view this content.

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.

[kev_]

Hi TBM
This is very similar to your previous thread. Have you abandoned that? Everything was put in a single macro in that thread.
Did you test the code that you have provided above? Given what you said in your other thread, I cannot see the above macros working because all the values for new file names came from different sheets - yet you have not referred to those individual sheets within the naming string.
In the code provided to you in the previous thread the correct sheet was referred to inside With.. End With each time - which is not the case here and neither have you activated the sheet - so how does VBA know in which sheet to find the values?

Spot the wrong "/" in your naming strings and amend to "\"

Why have you declared fName as Variant? A file name will always be a string.

Is this essentially the same question as the other thread? If it is, why start a new thread?

[TBM]

I could not get the old one to work.

I imagine that it was something I did wrong.

So starting fresh seemed like a good way to go.

Every code above works perfectly by itself.

I understand that it is a little hack and chop but it still works.

I thought showing what I am using may help others see where I want to go.

[kev_]

Giving up on a thread and starting another one is bad practice
- if everyone did that a lot of threads would end up incomplete and that helps nobody.

Let's go back to the ORIGINAL thread and get things working for you

[TBM]

Thank you for your help