Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111015
| From | Adrian Caspersz <email@here.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: EXCEL VBA Caching GET request? |
| Date | 2019-07-12 19:01 +0100 |
| Organization | Keep Usenet Text Newsgroups Alive!! |
| Message-ID | <gos08fF8sndU1@mid.individual.net> (permalink) |
| References | <f1f464fd-fcc3-4fd7-b3b0-03f54e5ff10b@googlegroups.com> |
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
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