【整理】VBA 访问 Web Service

1. 下载并安装 SOAP Toolkit 3

2. 引用 Microsoft SOAP Toolkit Library 3.0

3. 编写 宏

    Dim sc As New SoapClient30
    sc.MSSoapInit "http://CSZS19/RMSHostWebService/Service.asmx?wsdl"
    MsgBox sc.HelloWorld()