Hi,
You got to use an asynchronous call with the URL and then get back the response body.
From what I could remember,
there are other methods and properties such as getResponseHeader(method) & responseBody(property), which can be used according to your requirement. For more information just check the msdn library for the object MSXML2.XMLHTTP
Hope this helps.
Cheers,
Anil
You got to use an asynchronous call with the URL and then get back the response body.
From what I could remember,
Code:
Set httpObj = CreateObject("MSXML2.XMLHTTP")
httpObj.open "GET","Your URL", FALSE /*(False makes an asynchronous call)
httpObj.send
msgbox httpObj.responseTextthere are other methods and properties such as getResponseHeader(method) & responseBody(property), which can be used according to your requirement. For more information just check the msdn library for the object MSXML2.XMLHTTP
Hope this helps.
Cheers,
Anil