Use VBA to call Web Service

If you want to utilize web service in Excel, Word and other office tools. You have to use VBA to call web service.

Firstly, You must install the Microsoft Soap toolkit. The latest version is 3.0.

Secondly, you will add reference to you vba project. Select Tools--> Reference, select Microsoft soap type Library v3.0.

Thirdly, Edit you code to call web service.

 

Sub Button1_Click()Sub Button1_Click()
    Dim str As String
    Set Client = New SoapClient30
    Client.MSSoapInit "http://localhost:8866/Service.asmx?wsdl"
    str = Client.HelloPal("Guosong")
    MsgBox str
End Sub