Create multiple folders at once with Excel (the easy way!) | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file ★

★ About this video ★
Over the past few months, I have seen many videos showing how to create folders multiple folders at once using a .bat file (also known as a batch script).

Often these videos leverage Excel to create the folder paths. Then, they undertake various manual actions to get the .bat file into the correct location, so they can execute the script.

It may be better than manually creating folders, but I believe there is a much easier way to create folders with Excel.

In this video, we work through a small project to create a tool that creates multiple folders at once.

0:00 Introduction
0:25 Create one folder with VBA
1:37 Handling errors
2:34 Folder from cell value
3:05 Folders from multiple cells
4:33 Add a button
6:04 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

[captvo]

Excellent ! Thank you for sharing your knowledge🙏

[serdip]

Thanks for posting this very helpful video on automating folder creation.

For my applications, I make use of the FileSystemObject object, which has more methods and functions like FolderExists(), FileExists(), the Folders collection and the Files collection.

To take the solution to the next level, the range containing the folder names could be turned into a table. That way, the button could iterate through the table column without the user having to select the cells to be processed.

Thank you kindly.

[ziggle]

Your work on automating Excel is really inspiring me. Thanks for all you do!

[Arek-cu-when-we-get-there]

Great stuff! Thank you. I made attempt once in the past to create sub for changing time stamp of the file. I failed 🤷‍♂. I wonder if this can be done today with excel VBA ?

[babisflou]

Very nice method. We could even have as an input cell the parent directory that is same in all the directories listed and not have to input it that many times and be easier to change parent directory if needed. Eg from user to user or project to project.

[josephdaquila]

Wow, somehow I didn't realize Selection could be used in that way, just taking the value of what is selected. For some reason I thought it had to be a cell or range object that was selected. Not necessarily the value in that range or cell

[johnboffin]

Hello Sir, I have excel 2000, how can I do Table in excel 2000, Having table will help drop down list to grow as the list of stock grows. I tried few different ways but table doesn't seem to work.

[IvanCortinas_ES]

Excellent information Mark. I am doing tests.
In my case it creates a subfolder if the folder already exists. If the folder does not exist, it does not create the folder with subfolders.
Is this correct? I have to check.

[josephdaquila]

This is a bit of an implementation of "Lazy Initialization", correct?