G
Guest
What's the easiest way to check if a named path string exists ? (Boolean
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
P
PC Datasheet
Look at the Dir functionin the Help file.
A
Allen Browne
Try:
If Len(Dir("C:\SomePath", vbDirectory)) > 0 Then
If Len(Dir("C:\SomePath", vbDirectory)) > 0 Then
G
Guest
That was exactly what I needed!
Thanks.
Thanks.