How to call webservice with parameters in vba?

[Gdm]

Calling my web service without parameters works with this code:



sUrl = "http://www.mysite.com/MyService.asmx?op=MyFunction"
Set XMLHTTP = CreateObject("MSXML2.XMLHTTP")
XMLHTTP.Open "GET", sUrl, False
XMLHTTP.sEnd
byteData = XMLHTTP.responseBody

When I try to add parameters, it fails, with this url:
sUrl = "http://www.mysite.com/MyService.asmx?op=MyFunction&Parm1=abc&Parm2=def&P arm3=ghi"

The service is expecting 3 string parameters.

Any ideas most appreciated.

[June7]

So Parm1 and Parm2 and Parm3 are defined in MyFunction?

[Gdm]

Yes, Parm1, Parm2, and Parm3 are defined in MyFunction.

[June7]

Everything I've read says your code should work.

Possibly the issue is not with Access.

Bing: vb call web service with multiple parameters in url for function

This concerns SQLServer and passing parameters to a report. https://msdn.microsoft.com/en-us/lib...or=-2147217396

This seems to be similar to your issue http://scn.sap.com/thread/1689628