MkDir Command - how to use with the filename

[mel_flynn]

I need to use the MkDir Command when the string contains the required directory to be made and the filename.
e.g. I want to create a directory 'Directory1'

Dim fileLocation as String
fileLocation = "C:\Root\Directory1\file1.txt"

MkDir fileLocation

But I keep getting a Run-time error '76' Path not found. I know this is because I have the filename included in the string. How can I include the filename in the string without running into error?

Note: The file doesn't have to be created just the directory

[plenderj]

Private Sub someSub()
    Dim fileLocation as String
    fileLocation = "C:\Root\Directory1\file1.txt"
 
    MkDir returnPathOfFile(fileLocation)
End Sub
 
Private Function returnPathOfFile(ByVal strFile As String) As String
    returnPathOfFile = Left(strFile, InStrRev(strFile, "\"))
End Function

[beachbum]

Jamie is always drunk and so I think he misunderstood your question

You need to Make the directory first and then create files within it. If u want the text in a textbox to be the name of a file or directory just put it outside of the quotes... eg fileLocation = "C:\Root\Directory1\" & text1.text

[plenderj]

Originally posted by mel_flynn
I want to create a directory 'Directory1'

Note: The file doesn't have to be created just the directory

:p

[mel_flynn]

Good Stuff! Thanks

Now, say I want to make multiple directories in the one statement i.e. Directory1 and Directory 2 :

Private Sub someSub()
    Dim fileLocation as String
    fileLocation = "C:\Root\Directory1\Directory2\file1.txt"
    
    MkDir returnPathOfFile(FileLocation)
End Sub

Private Function returnPathOfFile(ByVal strFile As String) As String
    returnPathOfFile = Left(strFile, InStrRev(strFile, "\"))
End Function

I keep getting path not found with MkDir returnPathOfFile(FileLocation). I know this is because both directories don't exist ... so how can I make both??

[plenderj]

You have to make one at a time afaik

[KayJay]

As plenderj mentioned, you may have to write your own function for creating a nested directory structure. The one I used earlier is available at http://209.120.143.185/showthread.ph...hreadid=186500