finding whether a folder exists or not

[Kaverin]

If Dir$("c:\somedir", vbDirectory) <> "" Then
   'directory exists
Else
   'directory doesn't exist
End If

That should work even if the dir has no files in it, since you're explicitly looking for the dir.