Importing text data from the web

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>