Clear out internet cache with VBA

Excel Help for Clear Out Internet Cache With Vba in Building Market Trading Systems

Forum Topic

Clear Out Internet Cache With Vba

Rate this:

(3/5 from 1 vote)

The Internet cache is always a problem with web queries run from Excel. The problem is not just with Internet Explorer but also with any other browser such as Firefox. The solution is to clear out the cache from the VBA code before the process or loop within the process which can be done using a shell command. The VBA code is:

VBA Code:

Sub Clear_Internet_Cache()
Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255"
End Sub

Excel Business Forums Administrator

Posted by Excel Helper on 24 Nov 2009

View Full Post

Find relevant Excel templates and add-ins for Clear out internet cache with VBA in the Excel Business Solutions Directory