Forcing Excel VBA to make a request to a URL

Chris_Mugdan 

The URLDownloadToFile function in VBA typically caches the downloaded file to improve performance. However, if you want to ensure that the request is made to the remote server and not from the local cache, you can try appending a unique parameter to the URL. This will trick the cache into thinking it is a new request and force it to fetch the latest data from the server.

Here is an example of how you can modify your code to include a unique parameter:

Dim uniqueParam As String
uniqueParam = "&timestamp=" & Format(Now(), "yyyymmddhhmmss") ' Append a unique timestamp parameter

result = URLDownloadToFile(0&, _
    serverAddress & "\mapIntelligence\clientTemplates?action=list&" & params & uniqueParam, _
    LocalFilename, _
    BINDF_GETNEWESTVERSION & BINDF_NOWRITECACHE, _
    0&)

By adding the uniqueParam to the URL, it will change with each request, effectively bypassing the cache and ensuring that the latest data is fetched from the remote server.

Give this approach a try and see if it resolves the issue with fetching the updated data without having to restart Excel.