check for file before import

T

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
 
S

SusanV

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