i have a routine that goes to a web site and gets data. the data at the site changes often.
but there is a quirk.
in order to get the most recent data, i *always* have to quit excel completely, and then restart, re-run the routine to get the most recent data
i have manually cleared the cache and the cookies but i still get the same issue.
i have tried adding CInt(1000 * Rnd()) to the link to try and force the cache (or whatever is causing the trouble) to see the link as a new link to force it to give up the old data and bring in the new
but nothing works.
once i open excel, and get the data, i will not be able to get new data from the site
i am using
to get the data
is there some code that will emulate excel shutting down or something? somehow, somewhere excel is 'holing on' to something in re this particular site, or something like that.
all i know is the only way to fix the problem, to update and get the new data, i always have to close excel and then restart, which of course is a pain
any ideas ?
but there is a quirk.
in order to get the most recent data, i *always* have to quit excel completely, and then restart, re-run the routine to get the most recent data
i have manually cleared the cache and the cookies but i still get the same issue.
i have tried adding CInt(1000 * Rnd()) to the link to try and force the cache (or whatever is causing the trouble) to see the link as a new link to force it to give up the old data and bring in the new
but nothing works.
once i open excel, and get the data, i will not be able to get new data from the site
i am using
Code:
Dim objHTTP As Object
Set objHTTP = CreateObject("MSXML2.XMLHTTP")
objHTTP.Open "GET", [the link], false
objHTTP.send
set objHTTP = Nothing
to get the data
is there some code that will emulate excel shutting down or something? somehow, somewhere excel is 'holing on' to something in re this particular site, or something like that.
all i know is the only way to fix the problem, to update and get the new data, i always have to close excel and then restart, which of course is a pain
any ideas ?