Download file with Excel VBA generated from jsp over https

R

renderman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Merging from an Excel file with graphics 1
Secure FTP (https) and VBA 0
Handling internet explorer memory leaks from Excel VBA 0
Using VBA to run an Internet-based jsp 1
Access wab page with excel VBA 4
Download data from secure website into new Worksheet 12
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top