Web Query error returns
 

I am initiating a web query from VBA.

If the query fails I get an error which I can catch - all fine.

BUT

It allways returns 1004!!

Does anybody know how to detect the difference between, say,

cannot access internet at all
cant access that particular server
http status code (400, 404, 500 etc)

I am using XL2003

Web Query error returns
 

Hi Peter,

In Excel, try:

Data | Get External Data


---
Regards,
Norman


"Peter" wrote in message
ups.com...
I am initiating a web query from VBA.

If the query fails I get an error which I can catch - all fine.

BUT

It allways returns 1004!!

Does anybody know how to detect the difference between, say,

cannot access internet at all
cant access that particular server
http status code (400, 404, 500 etc)

I am using XL2003

Web Query error returns
 

Hi
- Yes data/get external data shows you on an IE window what happens.

My question is, when creating a web query programatically (using VBA)
how does one
discriminate between the different possible errors.


Peter

Norman Jones wrote:
Hi Peter,

In Excel, try:

Data | Get External Data


---
Regards,
Norman


"Peter" wrote in message
ups.com...
I am initiating a web query from VBA.

If the query fails I get an error which I can catch - all fine.

BUT

It allways returns 1004!!

Does anybody know how to detect the difference between, say,

cannot access internet at all
cant access that particular server
http status code (400, 404, 500 etc)

I am using XL2003

Web Query error returns
 

Depending on your coding skills you could always do a "head" request using an XMLHTTP object before running the web query, or even
perform the whole query using that method (depends on how complex the returned page is).

That will at least filter out the 404's etc and give you a readable error.

--
Tim Williams
Palo Alto, CA


"Peter" wrote in message ups.com...
Hi
- Yes data/get external data shows you on an IE window what happens.

My question is, when creating a web query programatically (using VBA)
how does one
discriminate between the different possible errors.


Peter

Norman Jones wrote:
Hi Peter,

In Excel, try:

Data | Get External Data


---
Regards,
Norman


"Peter" wrote in message
ups.com...
I am initiating a web query from VBA.

If the query fails I get an error which I can catch - all fine.

BUT

It allways returns 1004!!

Does anybody know how to detect the difference between, say,

cannot access internet at all
cant access that particular server
http status code (400, 404, 500 etc)

I am using XL2003