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

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



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

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

Dim arrayStudent() As Student

Call webservice.DoThings( arrayStudent )