Neo Gu


VBA Call WebServices in Excel. How to handle the returned/inputed empty complex array SOAPClient 3.0 Excel 2003

Hello,

These days I am using vba to call web services in Excel. One of the web services' return value is a complex array (like a table). When the web service return an empty array, it crashed with "SoapMapper: array dimensions do not match definition".

The other web service's input parameter is a complex array (like a table). When I call the web service using an empty array, it crashed with "Operation not supported".

It crashed outside the vba domain, seems in SOAPClient. Could anyone help me

Other guys facing the same question.

http://groups.google.com/group/microsoft.public.xml.soap/browse_thread/thread/029ee5b5d4fa2440