Home > Forum Home > Building Market Trading Systems > Downloading Market Data For Free > Web Query fails erratically Share

Web Query fails erratically

Excel Help for Web Query Fails Erratically in Building Market Trading Systems


Forum TopicLogin

Web Query Fails Erratically

Rate this:
(3/5 from 1 vote)
SadI too am having the same problem.  My web query is the same as what's shown in the original post in the VBA code box.  When I let the code run without an "on error" statement it sometimes errs on the ".Refresh BackgroundQuery:=False" statement and when I choose debug and then resume it executes fine till a few queries down the road and it fails the same way.  When I add an on error statement and have it do a resume with or without a 5 second wait it often fails the second and third times.

I had a similar macro working in 7 years ago under office 2000 using a dial up modem.  Now that I have Office 2007 and DSL my upgraded version works very spottily.  If anyone has a solution please post it.   
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Web Query fails erratically in the