Problems with Web Query

S

seegerp

I'm running Vista Home Premium and Excel 2007. Here's the issue.

I've created a web query by first recording a macro and then wrapping code
around the macro so that I can pass a url to the web query, grab the data on
the web page, and move to the next url. This is specifically for grabbing
data from Yahoo Finance so I'm passing a number of stock symbols to the web
query.

The code functions ok but when it executes a number of queries after around
10 or so it's unable to get the data from the web pages. And, it's a random
event. I can run the code a number of times and it will grab the first 10 or
15 stock symbols and then I begin to get errors.

Anyone had experience with this. I can supply the VB code. It's got a bunch
of stuff in it to check for valid stock symbols.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top