Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with Web Query
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
javascript causing web query problems | Excel Programming | |||
Query problems | Excel Discussion (Misc queries) | |||
Query Problems | Excel Programming | |||
Problems with Excel Web Query for Post Method URL | Excel Programming |