You receive an "unspecified client error" error message when you run a Visual Basic for Applications program (840925)

MORE INFORMATION

Steps to reproduce the problem

1. Install the correct version of the Web Services Toolkit:
   • If you are using Microsoft Office 2003, install the Microsoft Office 2003 Web Services Toolkit version 2.01.
     
     To download the Office 2003 Web Services Toolkit 2.01, visit the following Microsoft Web site:

     http://www.microsoft.com/downloads/details.aspx?FamilyID=fa36018a-e1cf-48a3-9b35-169d819ecf18

   • If you are using Microsoft Office XP or Microsoft Office 2000, install the Microsoft Office XP Web Services Toolkit version 2.0.
     
     To download the Office XP Web Services Toolkit 2.0, visit the following Microsoft Web site:

     http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst2/html/odc_offxpwstoolkit2.asp

2. Create an XML Web service that contains an XML Web service method that returns an ArrayList object:
   1. Start Microsoft Visual Studio .NET.
   2. Use Microsoft Visual Basic .NET to create a Microsoft ASP.NET Web Service project. Name the project MyService. By default, the Service1.asmx file is created.
   3. In the code view of the Service1.asmx file, locate the following code.

      End Class

   4. Add the following code before the code that you located in step c:

      <WebMethod()> _
      Public Function GetArrayList() As ArrayList
          Dim MyArrayList As New ArrayList
          MyArrayList.Add("Blue")
          MyArrayList.Add("Green")
          MyArrayList.Add("Red")
          Return MyArrayList
      End Function

   5. Build the solution to create the Service1 XML Web service.
3. Start Microsoft Excel.
4. On the Tools menu, point to Macro, and then click Visual Basic Editor. The VBA editor appears.
5. On the Tools menu, click Web Service References.
   • If you are using Office 2003, the Microsoft Office 2003 Web Services Toolkit dialog box appears.
   • If you are using Office XP or Office 2000, the Web Service References Tool 2.0 dialog box appears.
6. Click Web Service URL.
7. In the URL box, type the URL of the WSDL code that corresponds to the Service1 XML Web service. For example, if the URL of the Service1 XML Web service is http://MyServer/MyService/Service1.asmx, type http://MyServer/MyService/Service1.asmx?wsdl in the URL box.
8. Click Search. The Service1 XML Web service appears in the Search Results box.
9. In the Search Results box, click to select the Service1 check box, and then click Add. A class module that is named clsws_Service1 is added to your VBA project.
10. In Project Explorer, right-click VBAProject (Book1), point to Insert, and then click UserForm. The UserForm1 user form is added to the VBA project.
11. Add a command button to the UserForm1 user form. By default, the CommandButton1 command button is added to the UserForm1 user form.
12. Double-click CommandButton1 to open the code view of the UserForm1 user form.
13. Add the following code to the CommandButton1_Click event handler.

    Dim objArrayList As Variant
    Dim WebService As New clsws_Service1
    Dim Item As Variant
    
    objArrayList = WebService.wsm_GetArrayList
    
    For Each Item In objArrayList
    MsgBox Item
    Next

14. On the Run menu, click Run Sub/UserForm. The UserForm1 user form appears.
15. Click CommandButton1.