Use Excel 2003 XML Map feature to create an SOAP XML file?

M

mail_garp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert excel file to xml 0
Map one more column map within a single XSD element. 0
Changing a XML Source to include some additional elements. 0
Possible to export Excel data into in a SOAP envelope? 2
How to XML Map Repeating Rows? 2
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
XML Map Refresh on Open 0
Excel 2010 - Save as XML 0

Top