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
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