MrExcel.com - Your One Stop for Excel Tips & Solutions

Create a new folder using a variable

Posted by Jerry H. on August 06, 2001 10:49 AM

Is there a way to create a new folder using VBA that names the folder based on the contents of a cell?

Cell A1 = C:\windows\desktop\NewFolder\

Posted by faster on August 06, 2001 11:05 AM

this should do it
Sub MakeFolder()
MkDir (Range("A1").Text)
End Sub