Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111015

Re: EXCEL VBA Caching GET request?

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From Adrian Caspersz <email@here.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: EXCEL VBA Caching GET request?
Date Fri, 12 Jul 2019 19:01:51 +0100
Organization Keep Usenet Text Newsgroups Alive!!
Lines 19
Message-ID <gos08fF8sndU1@mid.individual.net> (permalink)
References <f1f464fd-fcc3-4fd7-b3b0-03f54e5ff10b@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding 7bit
X-Trace individual.net SklZlN0CC4cp7vSiZ8+iLwlmDPVboCutx22ITEUiFSRnjrc1Lm
Cancel-Lock sha1:NSgi9hTa3UksGrNS3M0dnI8bemk=
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.2
In-Reply-To <f1f464fd-fcc3-4fd7-b3b0-03f54e5ff10b@googlegroups.com>
Content-Language en-GB
Xref csiph.com microsoft.public.excel.programming:111015

Show key headers only | View raw

On 12/07/2019 09:15, armsiee wrote:

<snip>

> 
> If i close Excel down and reopen i get the new record.  I destroy all the variables after use.  I am not sure where to go next?  ANy pointers greatfullly received.
> 

The response from your URL is being cached somewhere in MSXML2.XMLHTTP60

Put a random parameter like a timestamp to the end of the URL

  i.e.

    sURL="http://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&t=20190202200423"


-- 
Adrian C

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

EXCEL VBA Caching GET request? armsiee <sjdolding@gmail.com> - 2019-07-12 01:15 -0700
  Re: EXCEL VBA Caching GET request? Adrian Caspersz <email@here.invalid> - 2019-07-12 19:01 +0100
    Re: EXCEL VBA Caching GET request? armsiee <sjdolding@gmail.com> - 2019-07-12 11:56 -0700

csiph-web