Programming Excel with VBA and .NET

Debugging Tip

One thing you will notice fairly quickly when using the Lists Web Service is that the error reporting is minimal. When a method fails on the server side, you receive only a general error. To receive more detail, make the following modification (shown in bold) to the clsws_Lists ListsErrorHander procedure:

Private Sub ListsErrorHandler(str_Function As String)
    If sc_Lists.FaultCode <> "" Then
        Err.Raise vbObjectError, str_Function, sc_Lists.FaultString & _
          vbCrLf & sc_Lists.Detail
    'Non SOAP Error
    Else
        Err.Raise Err.Number, str_Function, Err.Description
    End If
End Sub

Now errors will be reported with details from the server.