Hi
I am writing an excel vba module to download a file from a https webpage automatically.
At the moment, a user has to log in to a website and navigate to the specified page and click on the icon, the dialogue box to open or save the file comes up - which is fine.
I have written a vba routine to log in and navigate to webpage and find the object to click on to. However, internet explorer won't allow the dialogue box to come up and instead the messagebar at the top of the browser asks the user if it will allow the file to be downloaded. Is there anyway to bypass this or code to simulate an acknowledgement and get to the dialogue box? For the record, I am running this on a work network, where I have very limited access to the browser's security settings.
And in case, you suggest that I submit the web address for the download( I have tried that way too but there must be an additional check (not in the code) preventing me from doing this.
Thanks.
I am writing an excel vba module to download a file from a https webpage automatically.
At the moment, a user has to log in to a website and navigate to the specified page and click on the icon, the dialogue box to open or save the file comes up - which is fine.
I have written a vba routine to log in and navigate to webpage and find the object to click on to. However, internet explorer won't allow the dialogue box to come up and instead the messagebar at the top of the browser asks the user if it will allow the file to be downloaded. Is there anyway to bypass this or code to simulate an acknowledgement and get to the dialogue box? For the record, I am running this on a work network, where I have very limited access to the browser's security settings.
And in case, you suggest that I submit the web address for the download( I have tried that way too but there must be an additional check (not in the code) preventing me from doing this.
Thanks.
