For those of you that are trying to run a macro to retrieve stock quotes and are only getting a few returned before getting an error 1004, here is a work around. The problem is that whenever a retrieval is completed, a file is created in your Temporary Internet Files directory. I can only get between 17 and 20 of these files created before I start getting the macro error. The name is in the form of hp?s=AAPL for example. If you go in and delete these files and restart your macro, it will then run again until you get another 17 to 20 files built up. You can also just go in and clear your Temporary Internet Files directory which will also work. I would like to find a way to have the macro do this for me automatically. This problem just started happening a few month ago.
