How to Create Folders From Excel As You Type

How to Create Folders from Excel as You Type
Sometimes we need to create multiple folders from excel list. This type of folder creation is really tiresome. But now you can use VBA code create folders based on cell values. In this advanced excel tutorial, I’ll show you exactly how you can create multiple folders from excel as you type. If you follow the instructions from this video, you don’t need CMD to create folders from excel list. There are two tremendous features in this tutorial. You can create folders whenever you write the name inside any cell in Column A in excel. Also, you can paste a list in column A and the folders will be created automatically. All of this can be done using this excel tutorial.
Now let’s follow the instructions below to create folders based on cell values in excel.
Step 1: Open Microsoft Excel.
Step 2: Save the workbook in .xlsm format.
Step 3: Place the workbook where you want to create folders.
Step 4: Now open the workbook.
Step 5: Right Click on the Sheet Tab and Click on View Code.
Step 7: After writing the code you need to close the VBE (VBA Editor)
Step 8: Write something on Column A and press Enter and Done
Now go the location where you have workbook. You’ll see the folder created already. Now you can create folders using excel list. If you want you can paste the list in column A and it will automatically create folder on your computer from that list.
#Create #Folder #Excel
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[valmir]

It worked, but the entire code that I copied had an error. I removed the top portion of the code and started where is says "Sud-MakeFolder() and it worked just fine. Thank you for your support sir.

[lufski]

After submitting form, codes related mailed not received.

[dogukanduzgun]

hello sir I don't run your code because it error invalid processing every code countinuously I should make please help me. so thank you for this video

[damientranchant]

Hello, the link in description for the code is no longer working, could you please provide us a copy paste of the code ?

[leaannday]

I am having a little trouble with the code working. I have gone step by step 3 times and it doesn't create any folders.

[MattLeBlanc-vxnb]

How do I change code so that it uses what is in A column as well as B column to make up folder name?

[ayoub]

I tried to do it but didn't work? Any idea?

[alshaan-]

instead of folder can we make zip folder ? any chance

[normanilawatinilawati]

Hi after click the link, i still cannot find the code

[amrkorshoom]

Please the code link is not available anymore Thank you

[ycituwd]

please bro, i need the code, it says that the site can't be reached, when i click on " Get the Code" link,

[joannasmith]

Please share the code. Thank you! subscribed

[sherryavella]

please share code - thank you - subscribed

[oudomsomphone]

It doesn't work. I don't know what's the problem

[dnld]

as all the others, could you send me the code?

[dknechtle]

After submitting form, codes related mailed not received.

[mihailcrivat]

please share code - thank you - subscribed

[Mac-ufgm]

After submitting form, codes related mailed not received.

[shamilahzanthottath]

After submitting form, codes related mailed not received.