Does Directory Exist

[nmretd]

How can I check to see if a directory exists ?

[hayessj]

Use the dir() function, i.e. to see if d:\tmp exists use

If Dir("d:\tmp", vbDirectory) <> "" Then
MsgBox "Dir exists"
Else
MsgBox "Dir does not exist"
End If