Accessing an XML Web Service from Office 97

Question

Any body tried to access XML Web Services from Excel 97? Any feedback? Success?? Failure?? Precautions??

Administrator · Answer

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