Handling HTML dialog box to download file from website?

I am connecting to a web server through VBA, filling out a form by identifying the element names in the HTML of the webpage and posting the form to the site. That part works fine, and the report is generated on the screen. However, at that point, I'd like to be able to write some VBA code that will use the "Export" option on the webpage, in order to download the data for further manipulation.

The HTML code is below

Please Login or Register  to view this content.
Selecting the file format is easy....I want to download it in Excel format which is simply


Please Login or Register  to view this content.
However, when I use the ".Click" property of the "Export" link like so:

Please Login or Register  to view this content.
A new browser window and dialog box flash onto the screen briefly before disappearing. It's as if "Cancel" is the default setting for handling the dialog box, whereas I'd like it to "Save" the file, so I'm stuck at this point not knowing how to handle this problem.

The page uses Java functions, and I'm wondering if I'd need to somehow pass a parameter to one of the functions (perhaps "ReportViewerLink"?) in order to have it automatically download the file rather than cancelling. I'm also hoping there is an easy way to do this that doesn't require getting too technical with HTTPS and SSL connections....

Thanks