How to create Folder using VBA macro

[webmax]

Hi

I want to create one Folder and save Folder Name as Test using VBA Macro.

regards
shahul

 

[shrivallabha]

Try:

Public Sub MakeFolderVBA()
'\\Make sure that path "C:\Test" exists!
MkDir "C:\Test\Test"
End Sub

 

[webmax]

how to create multiple folders say example ten folders

 

[shrivallabha]

You can use the code posted in loop or repeat the line 10 times to get desired result.

Could you explain your requirement clearly?

 

[webmax]

i have a list of names in the excel sheets. i want to create the folder for the same and named in the excel sheets
for example in the the excel sheet range i have following names
Jan, Feb up to Dec. so the total name is 12 i want to create the 12 folders and folder name is jan, feb up to dec.

 

[shrivallabha]

Please go through the link and download the workbook I have posted there. I think it should help your cause.
http://chandoo.org/forum/threads/pl...subfolders-from-excel-cells.16052/#post-97386