check for file before import

[tecas]

How would I check for a file in a directory prior to importing it? The
file is stored on a server.

\\server01\importdir\importfile.txt

Would like to check if it is a location and check and provide an
alternate if not found there.

Any help would be greatly appreciated.

Thanks

 

[SusanV]

If Dir(filename) > "" Then
' import your file or whatever
Else
' messagebox or whatever
End if