Handling xsi:nil in Excel VB macro

[rtalockr]

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?

[ryanezs]

I've been looking for information on this topic for a long time. Did you get to solve that issue? Any help is kindly appreciated.