Hi guys and gals,
I am using the code below to pull data from a website :
Dim curl$
curl = "http://www.checkprice.nl/index.php?a=product_specs&product_id=" & Target.Value
Static oXml As Object
If oXml Is Nothing Then Set oXml = CreateObject("msxml2.xmlhttp")
With oXml
.Open "GET", curl, False
.send
Range("C" & Target.Row).Value = .responsetext
End With
Set oXml = Nothing
Exit Sub
However, this website requires a username and password to log in before showing the requested information. Is there any way I can send the username / password along with the request, so it logs in the website and gives me the correct responsetext?
Thanks so much for any help!
Bookmarks