\[code\]<?xml version="1.0" encoding="UTF-8"?><xa:MeContext id="ABCe0552553"><xa
ata id="ABCe05525531"><xaata id="1"><CustID>Cust1234</CustID><Name>Smith</Name><City>New York</City><Orders><order Orderid="101"><Product>MP3 Player</Product></order><order Orderid="102"><Product>Radio</Product></order></Orders></xn:MeContext>\[/code\]This well formed XML document feeds to Excel 2007 using MS VBA code. I was successful with using DOMDocument and IXMLDOMElement to import the Name, City, and Product.
However, the xa:MeContext id, vsData1 id, VsData2 id, CustID, and order Orderid numberwon't export to Excel sheet. This should be simple. This is my first post here.Each Excel row has the following headers with data filled from XML document:\[code\]MeContextID--vsData1--VsData2--CustID--Name--City--OrderID--Product--OrderID--Product\[/code\]
ata id="ABCe05525531"><xaata id="1"><CustID>Cust1234</CustID><Name>Smith</Name><City>New York</City><Orders><order Orderid="101"><Product>MP3 Player</Product></order><order Orderid="102"><Product>Radio</Product></order></Orders></xn:MeContext>\[/code\]This well formed XML document feeds to Excel 2007 using MS VBA code. I was successful with using DOMDocument and IXMLDOMElement to import the Name, City, and Product.However, the xa:MeContext id, vsData1 id, VsData2 id, CustID, and order Orderid numberwon't export to Excel sheet. This should be simple. This is my first post here.Each Excel row has the following headers with data filled from XML document:\[code\]MeContextID--vsData1--VsData2--CustID--Name--City--OrderID--Product--OrderID--Product\[/code\]