Testing for a path string

[Guest]

What's the easiest way to check if a named path string exists ? (Boolean

 

[Graham R Seach]

I assume you mean you want to test if a file (that's specified in a string)
actually exists.
If Dir(strPath, vbNormal) <> "" Then
MsgBox "The path exists"
Else
MsgBox "The path doesn't exist"
End If

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[PC Datasheet]

Look at the Dir functionin the Help file.

 

[Allen Browne]

Try:
If Len(Dir("C:\SomePath", vbDirectory)) > 0 Then

 

[Guest]

That was exactly what I needed!
Thanks.