If folder exist don't allow to create

[peryan77]

How would I go about allowing a user to create a folder in a given directory, but only if it does not already exist?

 

[jrbarnett]

Use code such as the following:

If Dir("C:\Data\Mystuff", vbDirectory) <> "" Then
  ' create the folder
  MkDir "C:\Data\Mystuff"
End If

John

 

[Craig0201]

Or

On Error Resume Next
MkDir "C:\Data\Mystuff"

Craig