Handling xsi:nil in Excel 03 VBA macro

[NewsBot]

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

 

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

 

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

 

 

 

The service works ok if all of the elements have a value.

 

What is the correct way to handle*elements that are xsi:nil="true"*in a VB office macro?

 

 

More...

 

View All Our Microsoft Related Feeds