VBA on Internet Explorer: Interact with the download dialog box (Save As / View / Cancel)

Hi everyone,

I'm desperately looking for a way to "accept a download" on IE from Excel with my VBA code run from MS Excel.
The source webpage contains a button that, when clicked, generates a pdf file and prepares the download (the file doesn't appear in any browser tab, only as a browser download proposition).

On the website itself the download request is (in HTML) as follows:

HTML Code: 

I am successfully accessing the download using:

Please Login or Register  to view this content.

The result is that Internet Explorer pops up the dialog box "Save As / View / Cancel ?".
I need to interact with this dialog box to accept the download or find an alternative way to download based solely on the URL.

This action needs to be repeated hundreds of times so either:
(1) disabling IE's dialog box to automatically accept downloads anytime (very dangerous, imho)
(2) finding a way to interact with the dialog box to accept download
(3) using a completely alternative coding method to download the file.

Thanks in advance for your help!!!

Use WinHTTP to stream the download to file rather than IE automation.

Thanks for the quick response, but I'm self-taught for VBA so I admit I've never heard of WinHTTP.
I tried to look up WinHTTP for VBA but can't figure out what it is I'm supposed to do.

Also, I have to log in via a secure web portal in order to access the file (hence the use of IE automation). Would WinHTTP work in this context?

Thanks in advance!