View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mail_garp@gmx.de is offline
external usenet poster
 
Posts: 1
Default 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.