VBA Utility - How to create Folder Structure using Excel VBA

Learn How to create folder structure using Excel VBA. Download the file and create folders and subfolders.
Excel File to download to create folders and Subfolders:
drive.google.c...
SUBSCRIBE: www.youtube.co...
#VBASessions #VBA #Excel

[@KhanhTruong-tf8qf]

Thank you very much, Mister. This video truly supports me a lot on my work!!

[@SessionsbySaurabh]

Thanks for your words

[@tonyquinn3941]

Thank you, having been tasked with multiple subfolders exceeding 40 main folders with 5 sub - subfolders, this is now a few minutes instead of days work. Regards Tony

[@saurabhjain3423]

Thanks Tony for your appreciating words.

[@shivanijain443]

Perfect. I have to create 50 folders daily. It's now a minute job. Thanks a lot for making life simple.

[@SessionsbySaurabh]

Thank you so much for taking time to leave a comment.

[@shisjsjndndj6230]

Awesome. Excellent video with all information. Thanks.

[@SessionsbySaurabh]

Thanks

[@nehasrivastav7541]

Very useful for my daily task in the office

[@harshiljain5523]

Awesome. Very useful. Thanks for sharing sheet.

[@SessionsbySaurabh]

Thanks

[@noorwazir]

Awesome. Excellent and Very useful video

[@SessionsbySaurabh]

Thanks a lot. Please share video with others.

[@maroufbenshi5155]

Thank you very much, this is very useful
I have a question, I want to create more than one folder within one folder
If this is possible?
Thanks in advance

[@SessionsbySaurabh]

Yes you can create multiple folders within one folder. In Structure sheet, in column A (Level 1) type folder name e.g. main and sub folder name in Column B (Level 2). To create multiple sub folders, type sub folder names in different rows keeping Level 1 same. E.g. If top folder name is MAIN and you want to create 3 sub folders within MAIN then type MAIN in cell A2, A3, and A4. Type subfolders name e.g. SUB1, SUB2 and SUB3 in cell B2, B3, and B4.

[@nithinnjoy937]

@@SessionsbySaurabh, Worked really well. Thank you.!!

[@severea4168]

Thank you, great file and very helpful. Only one issue which is I can't create folder names with Arabic letters . Any solution for this ?

[@SessionsbySaurabh]

Can you please share some examples of folder names having Arabic letters ? I will check and confirm.

[@BikeshJaiswal]

thanks for the video. But how can i create multiple subfolders in a particular folders.

[@SessionsbySaurabh]

Hi Bikesh, in the example we have created sub folders B1 and B12 in folder A1. So you just need to specify the structure in the structure sheet and the VBA will create multiple subfolders. If I didn't understand the query, please share the example of structure you want to create.

[@trang907]

It announced to create folders successfully but in windows, it cannot create folders

[@SessionsbySaurabh]

Please share the file structure you created in excel @ [e-mail]