VBA Code to download Issue List Excel Export

Hi - new to Jira and currently trying to figure out how to download the resulting export file from:

…/issues2/sr/jira.issueviews:searchrequest-excel-current-fields/temp/SearchRequest.xls?jqlQuery=project+%3D+PROJECTNAME+AND+fixVersion+is+EMPTY

I’m using VBA in MS Access. When I have an URL that points directly to a file, I have no problems downloading those. But this is different in that the URL doesn’t point to a file, but the response from the server is a file with a name that varies.

Can someone point me to the right resource reference where I can read and figure out how to do this?

Thank you,
HR