If you create the object "MSXML2.XMLHTTP", there is a GET method that will
return status text (OK if the URL is available).

For an example in script that can easily be incorporated into your VBA, take
a look at
http://www.microsoft.com/technet/scr...5/hey0222.mspx

Steve



"Lawood" wrote in message
...
With Excel 2003 I am importing data from the WEB. This works fine if the
file
exists, but not if it doesn't. I would like my macro to be able to handle
both cases. Guess what I am asking is there a way to check and see
whether
or not a file exists so I can handle it accordingly.