MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating folders.

Posted by Simon on November 17, 2001 3:01 AM

I am trying to work out how to create a new folder with a pathname derived from a text string contained in a cell.
I get the path (eg c:\data\ordering system\orders\t\test) using concatenate, then copy /paste_special/ value, and then want to create the folder using mkdir.
HELP PLEASE. I am going crazy!!!

Posted by Dank on November 17, 2001 3:19 AM

Say your folder path is in cell D5 you could use this code to create the folder:-

Sub MakeDirectory()
Dim strFolder As String

strFolder = Range("D5").Value
MkDir strFolder

End Sub

Hope it helps,

Posted by Simon on November 17, 2001 3:44 AM

Dank.....i tried that and it gave me a run time error 76 path not found.....