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
