I'm making a call to a web service from an Excel VB macro. I've loaded the .wsdl into Excel using MS Office 2003 Web Services Toolkit.

The .wsdl allows xsi:nil to be true on most elements in a SOAP response.

When running the service the macro fails if an element return nil. For example:

<bedrooms xsi:nil="true"/>

What is the correct way to handle this problem in a VB office macro?