Download file with Excel VBA generated from jsp over https
 

Hello,

I hope somebody can help me with the following problem:

I need to download a csv-file and copy part of the content to an excel
workbook. However, there are two complicating things:

1) the file is generated dynamically with a jsp script
2) the site is over https

I tried the following (in Excel VBA):

- Internet Transfer Control does not work because the Active-X Object
cannot be created (it is even not possible to add the control to a user
form)
- URLDownloadToFile cannot handle https (as far as I know)
- Using an Internet Explorer Object with Navigate method (know idea how
to prevent the download dialog that pops up)

I hope somebody can point me in the right direction.

Rgds,
Christian