Macro to Create Folder\Sub Folder\SubFolder\

**coolhit** · 08-22-2009, 09:09 AM

Hi,

Can i please ask for assistant.

I am trying to create a macro for button.

Please Login or Register  to view this content.

I know i have to use MKDIR but don't know how to write the code.

Column B Column C
Row 5 Drive Directory C
Row 6 Main Folder Bills
Row 7 Sub Folder 1 Insurance
Row 8 Sub Folder 2 Car
Row 9 Sub Folder 3 Ford
Row 10 Sub Folder 4 Max
Row 11 Sub Folder 5
Row 12 Sub Folder 6
Row 13 Sub Folder 7
Row 14 Sub Folder 8
Row 15 Sub Folder 9
Row 16 Sub Folder 10

As you see above user will enter the in column C drive\folder\sub folder\ etc.

cell B3 shows wahts the path will look like.

C:\Bills\Insurance\Car\Ford\Max\
If the folder exsit the display as meassage "Folder Exist - Please recheck".

I have attached file.

**royUK** · 08-22-2009, 10:54 AM

You cannot use MkDir to make complex directories as in your example, The main directory must already exist

If you want to create directory such as C:\TestMacro\Bills
, TestMacro must exist & the Function would create a subdirectory - Bills, in it

So this code will create the subdirectory if B2 produces C:\TestMacro\Bills & testMacro already exists
[

Please Login or Register  to view this content.

**shg** · 08-22-2009, 11:16 AM

Try this:

Please Login or Register  to view this content.

**coolhit** · 08-22-2009, 12:36 PM

Thank you very much works a treat.

Many Thanks

**royUK** · 08-22-2009, 12:59 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Hkortam** · 08-30-2012, 10:00 AM

How can I modify this macro to create multiple folders and subfolders?

**Cutter** · 08-30-2012, 12:43 PM

Hello Hkortam, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.