Handling xsi:nil in Excel 03 VBA macro

Joined
Jan 10, 2007
Messages
43,898
Location
In The Machine
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
 
Back
Top