Accessing an XML Web Service from Office 97

Hi, Assuming the office products support VBA, you should be able to just use the MS-SOAP toolkit (v3) and call stuff directly. I can do it no probs with VB Script, here is an example: Option Explicit Dim soapClient set soapclient = CreateObject("MSSOAP.SoapClient30") On Error Resume Next Call soapclient.mssoapinit("http://MyHost/HostIntegrationServiceWSDL/SessionManager.wsdl", "SessionManagerService", "SessionManagerServiceSoap") if err <> 0 then wscript.echo "initialization failed " + err.description end if wscript.echo soapclient.Signon("...") if err <> 0 then wscript.echo err.description wscript.echo "faultcode=" + soapclient.faultcode wscript.echo "faultstring=" + soapclient.faultstring wscript.echo "faultactor=" + soapclient.faultactor wscript.echo "detail=" + soapclient.detail end if Cheers

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
Hi, Assuming the office products support VBA, you should be able to just use the MS-SOAP toolkit (v3) and call stuff directly. I can do it no probs with VB Script, here is an example: Option Explicit Dim soapClient set soapclient = CreateObject("MSSOAP.SoapClient30") On Error Resume Next Call soapclient.mssoapinit("http://MyHost/HostIntegrationServiceWSDL/SessionManager.wsdl", "SessionManagerService", "SessionManagerServiceSoap") if err <> 0 then wscript.echo "initialization failed " + err.description end if wscript.echo soapclient.Signon("...") if err <> 0 then wscript.echo err.description wscript.echo "faultcode=" + soapclient.faultcode wscript.echo "faultstring=" + soapclient.faultstring wscript.echo "faultactor=" + soapclient.faultactor wscript.echo "detail=" + soapclient.detail end if Cheers