Handling xsi:nil in Excel VB macro
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?
Re: Handling xsi:nil in Excel VB macro
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.