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" <pd@p4pi.com> wrote in message
> news:1152780513.235971.317630@35g2000cwc.googlegroups.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
> >