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:


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,