The Best FREE Template to 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.

https://dsadsadsadsadsa.gumroad.com/l...

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.blogspo...

#excel #vba #exceltips