web query returned no data

[Titus]

Hi ive got a web query on a spreedsheet used for tracking the times when data
is changed on a site... i need this to work while im away from the computer
aswell so i set up a sheet that refreshes the data every 3 seconds then when
the data changes it trigures a macro that records the time the data changed.
The thing is very often it returns with the message - *The Web Query
returned no data, to modify....* is there any way to stop this message
showing and to make my web query keep refreshing till it gets a response?
Please Please help ive been stuck on this for 3 months!!!
in advance thankyou so so much for your time and effort

 

[Oliver Ferns via OfficeKB.com]

It might help if you told us what you have tried in the last three months.
Have you tried putting

Application.DisplayAlerts = False

in your code before you try to update the query? That *might* do it.

Hth,
Oli

 

[Titus]

Hi thanks for the reply... ive tryed lots and lots of those different types
of thing "aplicationdisplay alerts.. error trap on error ressume, but i just
found another post earlier talkibng about how this error is a bug in the
excel web querys.... so if thats true id say theres not alot i can do...
unless microsoft fix it