In referance to LPlates post of code:
Public Function DirExists(ByVal Directory As String) As Boolean
If Dir(strPath, vbDirectory) <> "" Then DirExists = True dir exists
End Function
CHANGES in BOLD TO MAKE IT WORK BELOW:
Public Function DirExists(ByVal strPath As String) As Boolean
If Dir(strPath, vbDirectory) <> "" Then DirExists = True 'dir exists
End Function
Sorry, just wanted to help and put my two cents worth..