EXCEL VBA Caching GET request?
On Friday, 12 July 2019 19:01:58 UTC+1, Adrian Caspersz wrote:
On 12/07/2019 09:15, armsiee wrote:
<snip
If i close Excel down and reopen i get the new record. I destroy all the variables after use. I am not sure where to go next? ANy pointers greatfullly received.
The response from your URL is being cached somewhere in MSXML2.XMLHTTP60
Put a random parameter like a timestamp to the end of the URL
i.e.
sURL="http://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&t=201902022 00423"
--
Adrian C
worked a treat! thanks Adrian.
|