web query returned no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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 :(
 
Back
Top