Automatically Create Folders From Excel

One topic I've been discussing for more than ten years, and keep coming back to with improvements, is how to automatically create folders from Excel. I originally shared a simple macro to make folders back in 2011. More recently, I showed how to add hyperlinks back to the newly created folders. But I was never quite happy with these programs. So now I'm back with a better, more powerful, and easy to use template that will instantly create folders for you.

This Excel template to create folders will teach you:

• How to use a macro to automatically create folders from Excel (duh)
• How to change the color of a toggle button (and how to use a toggle button in Excel)
• How to add hyperlinks to folders
• Conditional formatting to change cell color based on combo box selection
• How to copy existing folder names into Excel
• How to duplicate a file structure

As I've done with all my recent templates, I try to make them look as clean as possible when the user first opens the sheet so as not to overwhelm them. I like to use yellow to clearly show the cells that require user input. Command buttons make running your macros very easy.

I envision this template being used in two primary ways: to create a set of new folders from scratch (their names manually typed in), or to quickly duplicate an existing file structure.

https://excelspreadsheetshelp.blogspot.com/2022/04/the-best-free-template-to-automatically.html