View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default xmlhttp and ie cache

Jack,

Yes, massively simpler. Add a dummy parameter to your post and change the
dummy value to force a refresh.

e.g. something like
strPost = http://nnn.nnn.nnn.nnn/MyPage.asp?Param1=55&Param2= &
int(rand()*1000)

Robin Hammond
www.enhanceddatasystems.com

"Jack Clift" wrote in message
...
I am using xmlhttp.open and .send to retreive data from the internet. This
works ok but I have realised that the data retreived is not refreshed from
the web server, rather is being taken from ie cache (meaning that the data
is
effectively useless).

I have tried using .setrequestheaders with a variety of options. This did
not work.

Clearing the cache does force a requery of the web server, but is not a
practical solution.

I have found one suggestion in seaches on the web that indicated a
registry
setting be changed before the query, and then reset after - seems a bit
drastic for mine.

Is there a simpler solution to this?

thanks

JC