Hi
I have vba code to access a website to send sms. this code works fine when the internet explorer has no proxy. but it never works when using internet explorer with proxy. i have tried everything but cant find a solution. the code im using is:
can someone please help me.
many thanks in advance
I have vba code to access a website to send sms. this code works fine when the internet explorer has no proxy. but it never works when using internet explorer with proxy. i have tried everything but cant find a solution. the code im using is:
Code:
Dim objXMLHttp, sResponse
Set objXMLHttp = CreateObject("MSXML2.ServerXMLHTTP.6.0")
UserName = "user1"
Password = "pass1"
strMobile = Forms!Consumers!Mobile.Value
strMsg = "txt msg " & Forms!Consumers![FirstName].Value & " " & Forms!Consumers![LastName].Value
strAPIUrl = myurl
objXMLHttp.setProxy "2", myproxy, "<8080>"
objXMLHttp.Open "POST", strAPIUrl, False, UserName, Password
objXMLHttp.setProxyCredentials "HDWA\\k1, p1"
objXMLHttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHttp.send ("destination=" & URLEncode(strMobile) & "&text=" & URLEncode(strMsg))
sResponse = objXMLHttp.responseText
MsgBox sResponse
can someone please help me.
many thanks in advance