Posted to microsoft.public.excel.programming

Peter[_58_] Peter[_58_] is offline

external usenet poster

Posts: 8

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
web query url returns data, but not showing	Richard S[_2_]	Excel Discussion (Misc queries)	0	April 30th 09 04:29 PM
web query returns no data	Gary	Excel Programming	6	April 11th 06 09:52 PM
query only returns numeric - can I get characters ... ?	Hajime Kusakabe	Excel Programming	2	May 11th 05 03:09 PM
Query that returns a value to variable	mas	Excel Programming	0	March 7th 05 09:22 PM
DAO query/recordset returns with field names	Seth[_4_]	Excel Programming	0	August 18th 03 08:36 PM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us