98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Delete temporary internet files via VB
Delete temporary internet files via VB
Resolved · High Priority · Version 2003
Li-kim has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Delete temporary internet files via VB
I am running a web query across multiple parameters stored in multiple cells. After several iterations/loops, it stops working and returns a 1004 error. Looking on the web, it appears that too many similar queries have caused a naming convention error in my temp folder (http://www.mrexcel.com/forum/showthread.php?p=1795107). Other web queries appear to work fine.
Deleting the Temporary Internet History via Tools > Delete Browsing History helps but this has to be repeatedly performed manually. I have tried to use a Kill statement but that does not work as permissions are required (am on work PC). Is there a script that can do this simply?
RE: Delete temporary internet files via VB
Hello Li-kim
Thanks for your post and providing detail on your web queries.
We have reviewed this and our initial thoughts are that there may be a solution available but it lies beyond the scope of this forum.
We would need to review your working files and then produce a scope of work with durations and related costs. You will then be able to review and decide if you wish to proceed.
I will email you directly so if you want to discuss further you can reply to my email.
Kind regards
Jacob
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |