Web query failing due to too many temporary internet files?
 

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?

Web query failing due to too many temporary internet files?
 

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

--
Don Guillett
SalesAid Software

"gt" wrote in message
...
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?

Web query failing due to too many temporary internet files?
 

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/micro...ramming/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 ***