VBA HTTP request not updating

I have the following piece of code to simply pick up a date from a webpage.

Please Login or Register  to view this content.

It runs fine but to test it I changed the date in the database serving the php page but the answer it was pulling in is still the old value. If I check the php page it queries online it gives the new date. I'm presuming I have either to close the request or force a refresh but no idea how. Can anyone give me any pointers? TIA

if you want to terminate any memory that's stuck, just quit excel. is that what you're asking? according to this:

https://docs.microsoft.com/en-us/pre...57849(v=vs.85)

your bool arg is not causing async. so that's the easiest way to do it, obviously, in terms of using resources that are NOT risky. async is the worst, because it is heavily overused and no-one has any control over when it gets stuck and has to be forced to quit by manual work done by humans. it's not perfect, nor has it ever been. have you looked here?

https://www.google.com/search?q=MSXM...nse+text+wrong

or here?

https://www.google.com/search?q=MSXM...t+return+wrong

Thanks for that. I'll get a better look later but closing it is not really an option in the long term due to the way it is likely to be used. I had sort of thought there may be a "refresh" type issue. I'll check those links though. Thanks.

here's some more:

https://www.google.com/search?q=vba+...method+refresh

https://www.google.com/search?q=vba+...equest+refresh

and someone else apparently complained about the same thing you are complaining about:

https://stackoverflow.com/questions/...-doesnt-update

Thanks for these. After reading through them I went with adding the line:

Please Login or Register  to view this content.

WHich, at least the first couple of times of trying, appears to have solved the issue.

well good for you!

In case someone else stumbles on this it appears it doesn't always work.