1 New Message
Digest #2555
Message
Wed Mar 20, 2013 10:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check the LINKS area of the Yahoo Group. There is an item there that tells
you how to change your Internet Options so that IE (and XMLHTTP) will
always get a new copy of the web page. It is one of the items concerning
smfForceRecalculation.
On Wed, Mar 20, 2013 at 10:30 PM, tar044 <tar044@yahoo.com > wrote:
>
> Maybe this info will be useful, maybe not. You probably already know
> it.
>
> I was having trouble with my spreadsheet not updating, using your
> smfForceRecalculation and even manually. I could see the info on the
> website had newer and different data than the spreadsheet. After many
> hours of debugging I traced it to the XMLHTTP not making a new request
> to the website, but rather pulling some (microsoft) cached data from
> somewhere (I think we all know where).
>
> After many many more hours googling this I found a solution here:
> https://groups.google.com/forum/?hl=en&fromgroups=# !topic/microsoft.publ\
> ic.excel.programming/oRQeipGKCzM
>
> I implemeted this by moding a line in your "RCHGetURLData1" function
> (for my case) as follows:
>
> Original:
> oHTTP.Open pType, pURL, False
>
> Modified:
> oHTTP.Open pType, pURL & "&" & Format(Time, "hhmmss"), False
>
>
> It now updates everytime I run your "smfForceRecalculation" macro.
>
> If you know of how to modify these magical microsoft cache settings I
> would be interested. I could not find that after many additional hours
> of googling.
>
> Note: I am a poor googler.
>
you how to change your Internet Options so that IE (and XMLHTTP) will
always get a new copy of the web page. It is one of the items concerning
smfForceRecalculati
On Wed, Mar 20, 2013 at 10:30 PM, tar044 <tar044@yahoo.
>
> Maybe this info will be useful, maybe not. You probably already know
> it.
>
> I was having trouble with my spreadsheet not updating, using your
> smfForceRecalculati
> website had newer and different data than the spreadsheet. After many
> hours of debugging I traced it to the XMLHTTP not making a new request
> to the website, but rather pulling some (microsoft) cached data from
> somewhere (I think we all know where).
>
> After many many more hours googling this I found a solution here:
> https://groups.
> ic.excel.programmin
>
> I implemeted this by moding a line in your "RCHGetURLData
> (for my case) as follows:
>
> Original:
> oHTTP.Open pType, pURL, False
>
> Modified:
> oHTTP.Open pType, pURL & "&" & Format(Time, "hhmmss"
>
>
> It now updates everytime I run your "smfForceRecal
>
> If you know of how to modify these magical microsoft cache settings I
> would be interested. I could not find that after many additional hours
> of googling.
>
> Note: I am a poor googler.
>
Tidak ada komentar:
Posting Komentar