url data is not updated in a vba loop

[bloepje]

Hello, My problem/challenge is the following: I have a URL that can display the electricity consumption of my home at time "X", this works perfectly, but if I make a loop in VBA for example of 5 minutes, then it changes the value of the data not, (remains the same every 5 minutes) only when I close Excel and then start it again is the data updated

 

[Domenic]

Which object are you using in order to make your request, XMLHTTP60 or ServerXMLHTTP60 ? Or something else? If you're using XMLHTTP60, try amending your code by adding the following lines after you open your http request, but before you send it...

jsonhttp.setRequestHeader "pragma", "no-cache"
jsonhttp.setRequestHeader "cache-control", "no-cache"

...which basically instructs it to make a server request instead of referring to the cache.

Hope this helps!