Use VBA Detect File Location

[Ross]

How can I use VBA to test a File Location to determine
that it is valid, ie that it exists?

Thanks,

Ross

 

[Cheryl Fischer]

Check out the Dir() function.

 

[Marshall Barton]

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

 

[Guest]

Marsh, Thanks so much!

-----Original Message-----


Use the Dir function:

If Dir(fullpath) = "" Then
'no such file
Else
'file found
End If

 

[Ross]

Thank you Cheryl!

-----Original Message-----
Check out the Dir() function.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.