View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
venk venk is offline
external usenet poster
 
Posts: 3
Default XMLHTTP.OPEN + PASSWORD + USERNAME

Dear friends,
using xmlhttp.open i am able to connect to a webservice.
in the envelop i can include user name and password and i can invoke the
webservice method. good job. thanks!.

but now , i have to connect to a website www.venki.com this will take you
to the login page, if you are not logged into the website.

and i have to access http://www.venki.com/returndataSet.a...me=ven?lname=n...
this page. i dont want any result set back.

My idea is when we open
http://www.venki.com/returndataSet.a...me=ven?lname=n... this page should be
able to see the result without logging in. i am logging into the website
programmatically lets say from vba using
oXMLHTTP.Open "GET", "http://www.venki.com/Login.aspx", False, "venki", "ven"
if we have logged into the website this way then we should be able to see
the results without getting redirected to Login.aspx page.

but oXMLHTTP.Open is not working i guess.
advice me please