Web query failing due to too many temporary internet files?

[gt]

I have a spreadsheet that pulls stock information off of Yahoo Finance. I
have vba code that goes through a list of stock symbols and pulls up a web
query for each then taking the data and copying elsewhere in the workbook.

I've been using this query for years with no problem. Suddenly, about a week
ago the query would start failing after running a certain number of symbols
(typically about 50 or 60). When I would manually try to refresh the query in
the spreadsheet it would give me an error that said that the query is
incorrectly formatted.

I did all kinds of messing with my web settings to see if anything fixes it.
I finally deleted all of my temporary internet files and it started working
again. But, one catch, I can only run 50 or 60 symbols before the problem
starts happening again! If I delete temporary internet files I can run
through the next 50 or 60 symbols. Big pain! If I go to the temporary
internet files directory I see a bunch of "q?s=XXX" files where "XXX" is the
symbol. I know they are the culprit because if I delete just those files it
starts working.

So, questions would be:
- Has anyone run into something similar?
- I tried to use VBA code (Kill command) to delete temporary internet files,
but I think it can't find them because they are hidden/system. Anyone know of
code that can do this?
- Is there a way to force excel to not cache?
- Any other ideas?

 

[Don Guillett]

You may be building up too many names due to your query.
You may send me your workbook to the address below and I will take a look.
I have a free file at the yahoo xltraders group that you may like

 

[Aaron Nuetzman]

I am running into the same problem. Once I empty out the files
everything works fine. I came across this link in a google group.

http://groups.google.com/group/microsoft.public.excel.programming/browse
_thread/thread/9a7d1c37ce74e992/ce3adf71dd58a614%23ce3adf71dd58a614

I haven't looked at it in detail, but it looks like there is probably a
way to get this done. Let me know what you find out and I will do the
same.



*** Sent via Developersdex http://www.developersdex.com ***