I need to read and download some files from an external site. Meaning right now they go to that site ( a finanical secure web site) with their userid, password and their screen has list of files (csv,pdf etc.) they click on it and download.
I am trying to automate this process. Tried with XMLHTTP, but probably security will not let me in.
Response.Buffer = false
Dim objXMLHTTP, xml
Set xml = Server.CreateObject("Micro
xml.Open "GET", "https://somesecuresite.com/acweb/hou-actuate-prd/__login
", False, "myid", "mypass"
Response.ContentType = "text/xml"
Set xml = Nothing
This doesn't work and returns a 401
Any suggestions ?
When I manually go to that site it generates some querystring characters with a successful login just like hotmail.
My question is : how do I read and download and attachment from a hotmail kind of system