Hi
I want to donwload a file from a web (HTTPS) so I log in, right click the link and select save as specify path/filename and save.
I want to do the same use using VBA
Set IE = CreateObject("I nternetExplorer .Application")
or at least after I log in specify the full path which I have and save as
-- Currently I get a pop up with open, save, cancel option
IE.navigate sURL ' and save as somewhere
or use
Set oXHTTP = CreateObject("M SXML2.XMLHTTP")
Set oStream = CreateObject("A DODB.Stream")
but when I save it saves some HTML content and not the actual xls file.
Many thanks in advance
Emil
I want to donwload a file from a web (HTTPS) so I log in, right click the link and select save as specify path/filename and save.
I want to do the same use using VBA
Set IE = CreateObject("I nternetExplorer .Application")
or at least after I log in specify the full path which I have and save as
-- Currently I get a pop up with open, save, cancel option
IE.navigate sURL ' and save as somewhere
or use
Set oXHTTP = CreateObject("M SXML2.XMLHTTP")
Set oStream = CreateObject("A DODB.Stream")
but when I save it saves some HTML content and not the actual xls file.
Many thanks in advance
Emil