Create folders and Sub folders and Sub-Sub folders from 5 columns with VBA

Hello all,

After reading through several forums and trying this myself... I'm stuck. I am trying to create Folders with sub folders and sub sub folders!

Each job# in column "A" should have its own folder in My Documents. For each Job folder (column "A") there should be two sub folders, "PRE CX" and "CX" (Cells B3 and D3). In the "PRE CX" sub folder there should be one folder for each cell in column C. In the CX subfolder there should be one folder for each cell in column D. All Sub folders/Sub Sub folder should have the Job# then the folder name for example "SS132 PRE CX"

I have attached a workbook with what I'm trying to accomplish, any help would be HUGE!

Thanks in advanced,
Alex

folder maker.xlsm

Hi bsalv,

I have never used the Microsoft Shell Controls and Automation and I am running into a problem with the code as is. I get a Run-time error '13': type mismatch. Any help would be appreciated.

Thanks Alex

Hey bsalv,

I figured out to enable Microsoft Shell Controls and Automation but now I'm hitting a "Run-time '91': Object variable of With block variable not set" and it highlights the line

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Alex

Sorry bsalv, I guess I should stare at the code a little longer before posting, its working great. The only thing that I am running into it that it isn't naming the sub folders with job name first. Im sure there is a way to append this code to include that I'm just not sure what that is. Thank you for your continued help!

Alex