Skip to Content
0
Former Member
Apr 30, 2007 at 05:08 AM

VBA Call WebServices: How to handle a returned empty complex array?

71 Views

Hi,

These days I got a task to call a web service by VBA in Excel, but faced the following two problems about empty complex array.

<b>1. When the returned value of a web service contains empty array, it crashed with "SoapMapper: array dimensions do not match definition"</b>

Another guy faced the same question with me, detail at http://www.topxml.com/SOAPToolkit/rn-246726_SoapMapper-array-dimensions-do-not-match-definition.aspx

<b>2. When the input parameter contains empty array, it crashed with "Operation Not Supported"</b>

Dim arrayStudent() As Student

Call webservice.DoThings( arrayStudent )