Create New Folder?

[davidgottlieb]

Is it possible to write code to create a folder. What I want to do is if this folder does not exist, create the folder and save the file. How can I do this?

[damonous]

Take a look at the FileSystemObject.

[Yonatan]

Try the MkDir procedure.

[davidgottlieb]

How do I do that? I am a beginner. Also, keep in mind I am using VBA. Please help

[HeSaidJoe]

Private Sub Form_Load()

'check to see if a dir exists

Dim sDir As String
sDir = "C:\my documents\helpmeout"

  If Dir(sDir, vbDirectory) <> "" Then
    MsgBox "Exist"
  Else
    ChDir "C:\my documents"
    MkDir (sDir)
    'then do your save or whatever
  End If

End Sub