Testing if a network file exists?

[GasSensor]

I've had a good search on the Net for any help on this question without success. In my Excel (2003) macro, I want to open a text file that is on a different PC. I have a test to see if it exists, but if the network connection to that other PC is down, my test crashes.

My test at the moment looks like:

Please Login or Register  to view this content.

where sFullFileName is a string with the full path which can be something like:
\\stage2test\C\Data\Sensors\Logs\27272.txt

The test works when the network connection is there. How can I test the network connection to the other PC?

Thanks,
Neil

[royUK]

Welcome to the Forum. Please take the time to read the Rules & use Code tags in future. I will add them for you this time.

[royUK]

This might help

http://www.tek-tips.com/viewthread.cfm?qid=768126

[GasSensor]

Sorry for not posting properly.

Thanks for the link, that seems to do just what I want.

[royUK]

No problem glad that helped.