R
Ross
How can I use VBA to test a File Location to determine
that it is valid, ie that it exists?
Thanks,
Ross
that it is valid, ie that it exists?
Thanks,
Ross
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.
C
Cheryl Fischer
Check out the Dir() function.
M
Marshall Barton
Ross said:How can I use VBA to test a File Location to determine
that it is valid, ie that it exists?
Use the Dir function:
If Dir(fullpath) = "" Then
'no such file
Else
'file found
End If
G
Guest
Marsh, Thanks so much!
-----Original Message-----
Use the Dir function:
If Dir(fullpath) = "" Then
'no such file
Else
'file found
End If
R
Ross
Thank you Cheryl!
-----Original Message-----
Check out the Dir() function.
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
.