Create folders and subfolder based on 2 cell values

Hi all,

I tried to create a folder structure per client based on an excel sheet that I receive per email and needs to be processed.
In column B there is the BIN number and in Column D the client name. The sub folders have all the same naming convention and it would look like this:

12345_Client Name Inc.
Documents
Emails

I have the below code, but it only takes from the selected range in a column range and then I miss the client name in the main folder.
It is possible that we need to add a few more folders and it would need to be flexible (also work in excel 2000, 2003, 2007 and 2010).
Any chance to find better solution?

Please Login or Register  to view this content.

Once the main folder and sub folders are created, we need to send the person that will work on the case the path to the folder.
So if the path could be captured as a value and that one I could pass to the email that we send, will for sure improve our work.


Greetings.

Try this

Please Login or Register  to view this content.

Hi,
That works great :-)
What about getting the path of the main folder and pass it to memory so I paste the link in an email that I create with a macro?

greetings.

I cannot say for sure if I got your target but try this .. you will get a message of the path for each subfolder of Emails

Please Login or Register  to view this content.

Hi,

This works great and I can pass the strPath for the email creation.
One silly question, what happens if the folder already exist? (some one created before)

Greetings.