When you access websites through the browser, caching speeds perceived access since it only actually downloads data for pages and images that seem to have been modified since the last time you accessed them. There is actually caching happening all over the internet between you and the site you are accessing, so occasionally something goes wrong - you don't get the latest version of the data you are accessing. In How to update modules automatically in VBA, data is retrieved using the xmlHTTP object, and sometimes it does not recognize that data has been updated, and returns the cached version. Here's how gistThat gets over this problem, ( a solution that can be applied to any case you suspect as not refreshing web caches correctly). URL parametersAlthough there are http headers you can tweak to indicate that the response should not come from cache, they seem not to work reliably. Instead - here's a way to use a bogus and random parameter in your URL so that it looks like a different URL to the you previously accessed, thereby forcing the response to be freshly downloaded. Just pass your URL to this function, and use the modifed one returned by this function instead.
|
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Get Started Snippets >