Use Excel 2003 XML Map feature to create an SOAP XML file?
Hi,
I would like to you the XML support in Excel 2003 to create an SOAP XML file. I tried to create an xsd file or use an existing SOAP XML data file but I struggle a bit with the SOAP envelope / SOAP namespace etc. XSD isn't working as I can't define there the SOAP envelope element etc. SOAP XML data file isn't working as map as Excel renames the SOAP envelope to ns1 etc. and therefore once I do a XML save a non valid SOAP XML is generated although the "real" data elements are correct. Anyone an idea if I can create somehow with the XML map + XML save a SOAP XML file? Or is this really not possible and I have to use VBA? If the latter examples/links would be highly appreciated. Thanks in advance for all replies. |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com