Hello all,
I am currently trying to write a VBA program that would download excel files from a password protected website.
The first issue that I have is that the function URLDownloadToFile doesn't work as the files are protected.
The second issue that I have, is that when I navigate the webpage with VBA and that I find the link to the file, when I do the "IE.navigate file_url", sometimes it directly opens the file in excel, and sometimes the popup "File Download" appears.
I would like to know if it it possible to force this popup to open (something like a right click on the link followed by a click on "save target as"), or if a function like URLDownloadToFile could directly connect to my IE, and avoid the login and password already entered in the website.
Thank you very much for your help,
Edouard
I am currently trying to write a VBA program that would download excel files from a password protected website.
The first issue that I have is that the function URLDownloadToFile doesn't work as the files are protected.
The second issue that I have, is that when I navigate the webpage with VBA and that I find the link to the file, when I do the "IE.navigate file_url", sometimes it directly opens the file in excel, and sometimes the popup "File Download" appears.
I would like to know if it it possible to force this popup to open (something like a right click on the link followed by a click on "save target as"), or if a function like URLDownloadToFile could directly connect to my IE, and avoid the login and password already entered in the website.
Thank you very much for your help,
Edouard
