Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open temporary internet files | Excel Discussion (Misc queries) | |||
Data query failing | Excel Worksheet Functions | |||
Can VBA clear the Temporary Internet File folder? | Excel Programming | |||
Delete Temporary internet files | Excel Programming | |||
Listing Temporary Internet Files | Excel Programming |