MSXML2.XMLHTTP not refreshing or updating

[johnbird1988]

Hello,

I have a query that connect to a API to update a set of data. The problem I am having is once the date first loads any further updates do not update. It is like the connections has been cache or something.

Is there a way I can clear the cache so it will update every time it is run.

A copy of the subset below:

Set http = CreateObject("MSXML2.XMLHTTP")
http.Open "GET", iURL, False
http.Send

Thanks, John

 

[Haluk]

Try the code like this;

Set http = CreateObject("MSXML2.[COLOR=#ff0000][B]Server[/B][/COLOR]XMLHTTP")