Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some macros that go down a list of stock symbols, grab historical data
from Yahoo!, and then graph the data. The macros work well, but there's one glitch. To test the code, I put a bogus stock symbol in (FMA - doesn't exist). I have an "On Error Goto" statement just before the web query, and when I try to query this symbol, the error trips and sends the macro to the recovery code. However, when I put two bad symbols in the list, the first one still trips the "On Error", but the second one doesn't - instead the VBA debugger gives me a run time error '1004' message: "The Internet site reports that the item you requested could not be found. (HTTP/1.0 404)" I can't figure out why the error trapping doesn't work the second time around. The bogus stock symbols can be next to each other, or separated by other "good" symbols, and the second one still doesn't work. Any ideas? Thanks, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error on Working Macro | Excel Discussion (Misc queries) | |||
On error resume next not working | Excel Discussion (Misc queries) | |||
Error Trap not working | Excel Programming | |||
Error Handler Not Working | Excel Discussion (Misc queries) | |||
error 50290 when working from dll | Excel Programming |