Web Query Query

[TiTuS]

Hi,
Just a problem im having is i have lots of web querys in my sheet. alot of the time i get the error saying no data returned when they refresh i was wondering if the following code could be changed to work with a web query and if it would delay the error coming up till data is recived? or even better does anyone have a code to cancel out that error but still have the query refresh till data is recieved, the reason i need this error gone is i have a query that refreshes every second to trace the exact time data changes on a site. so if that error keeps coming up it defeats the pupose of been able to leave the sheet to run itself

code:
--------------------------------------------------------------------------------

ActiveWorkBook.RefreshAll
With Worksheets(1).QueryTables(1)
Do While .Refreshing = True
Loop
End With
ExistFault.Show

 

[NateO]

See the VBE help file on the Refresh Method. You want to set the BackgroundQuery argument to False, e.g.,

Sheets(1).QueryTables(1).Refresh BackgroundQuery:=False
MsgBox "Hello World Wide Web!!"

 

[TiTuS]

This did not work in eliminating the error, anyone else able to help?
This is a problem that i know alot of people have found with web query's and when searching the web for a way round it i only find others asking the same question on how to... but so far ive found no answers, please if you know can you let all us wondering people in on your code! Thanks so much,

Tim

 

[NateO]

Thanks for following up Tim. I have a few questions at this point:

What did you want?

What did you try?

What did you get?