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