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.

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.

Thanks. This worked fine. Maybe not significant but I noticed this process
does not ask for my Web Site USERID/PASSWORD (the web site data is returned)
whereas the Import data does.

"Steve Yandl" wrote:

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.