Web Query hangs Excel

  • Thread starter Thread starter Monshi
  • Start date Start date
M

Monshi

When issuing a web query and this query doesn't get a
correct response from the webserver Excel often stops
responding.

Sometimes it gives back an error message, telling it
couldn't connect or something like that, mostly it halts
and doesn't enter any errohandling loops. Only way to stop
it is to terminate Excel.

The query I'm running is simple, it collects goal-data in
fotball matches from this source:
http://www.svt.se/texttv/377.html (area Målservice)

Do there exist any simple fix for this or will I have to
write an own query timeout routine using classes, events
and an scheduled (OnTime) procedure?

Running Excel 2002
 
Alrigh, no respons.

Perhaps I have solved this by using events Before and After
refresh and the application.ontime function. I hope this
will work, but if anyone has another solution to this
error, please post it!

/T
 
I also have the same problem with Excel Web Query. I would appreciate it if you could help providing your example codes in using events Before and After refresh and the Application.Ontime function to solve this problem.

Thanks in advance for your help
/gts

Monshi said:
Alrigh, no respons.

Perhaps I have solved this by using events Before and After
refresh and the application.ontime function. I hope this
will work, but if anyone has another solution to this
error, please post it!

/T


>-----Original Message-----
>When issuing a web query and this query doesn't get a
>correct response from the webserver Excel often stops
>responding.
Click to expand...
 
Back
Top