Code to create Folders and sub folders based on variable cell values

[maxwell13]

Hello

I would like some assistance to be able to check if a folder exists and if not, create that folder and sub folders based on variable cell values

If cell A1 = Red
cell A2 = Blue
cell A3 = Green

The Folder created would be c:\Red\Blue\Green

Any assistance is greatly appreciated

Thanks

Jeff

[LokeshKumar]

Hi,

Just try this......not as you wanted just created for some one else....Create Directories.xlsm
See If it could help you......

[humdingaling]

not sure why you posted that file if its not what the OP asked for....
it doesnt even have any code as such can not even be adapted to suit the OP


as you cannot make green until Blue folder exist
http://www.techonthenet.com/excel/formulas/mkdir.php

its 3 step process

Please Login or Register  to view this content.

[humdingaling]

of course if the values in ranges are not folder compatible this code breaks down

shorter str version

Please Login or Register  to view this content.

[maxwell13]

Hi humdingaling


Thanks for your reply and code

I have created the path C:\Users\vthang\Downloads however both versions crash at the first Mkdir str line

Thanks

Jeff

[humdingaling]

whoops, forgot to change back after testing
just make first = [str = "C:\"] instead

thats my username and download section which is why it wouldnt work because that directory wouldnt exist on your system

ie

Please Login or Register  to view this content.

[maxwell13]

Excellent all working perfectly now

Thanks for your help

[maxwell13]

Hi Again

Not sure if I should have started a new thread but I would like to take this a step further and now use save as to save this file into the last created folder with the file name being the value in cell B1.

The last part I can do however i'm not sure how to reference the newly created folders.

Thanks

Jeff

[humdingaling]

if you add it in the existing code
str would be the drive and path as string

Please Login or Register  to view this content.

should save the file in the newly created folder
this is where it will go if
you use the workbook.save or saveas afterwards

[maxwell13]

Once again thank you I got that going all OK.

I added after

Please Login or Register  to view this content.

Thanks

Jeff

[humdingaling]

sure not a problem

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.