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