Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
web query url returns data, but not showing | Excel Discussion (Misc queries) | |||
web query returns no data | Excel Programming | |||
query only returns numeric - can I get characters ... ? | Excel Programming | |||
Query that returns a value to variable | Excel Programming | |||
DAO query/recordset returns with field names | Excel Programming |