Create folders programmatically with MS Excel
One of my best friends wanted a software which will generate folders based on an excel sheet.
Guess what I suggested ? Initially Ruby 😅 because I just ❤ it
later, I remembered the most easiest way.
And that is using The Macro feature in Ms Excel.
I am writing this article to explain how you can create your own macro to create folders based on an excel column.
1. Add developer option into your Ms Excel
I hope you have already opened the Ms Excel :). And also skip this step if you have the developer option like bellow in the ribbon.
File → Options
Select Customize Ribbon → Tick the developer option
2. Do the Macro
Developer → Visual Basic
This will open a new window. like this
Now you have to create a new Module for the task
So Insert → Module
Now Insert the code to generate the folders based on the selected column names
Save it by whatever a name. 😄
3. Last part using a HAPPY DEMO
Go to your excel sheet, type some random names in the sheet.
select the names
Go to developer → Macros
I saved the Macro as MakeFolders,
Just RUN it and see the magic. ❤
Happy macro with Excel ❤