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

Using VBA to run an Internet-based jsp 1
Open an Excel file located in a web page - How to open it 0
Access wab page with excel VBA 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Download a .csv file from a website 2
Download data from secure website into new Worksheet 12
Popup download file over https 3
Handling internet explorer memory leaks from Excel VBA 0

Top