title: Parse Data in XML Document to Excel Worksheet
body: <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;xa:MeContext id="ABCe0552553"&gt;
    &lt;xa:Data id="ABCe05525531" /&gt;
    &lt;xa:Data id="1" /&gt;
    &lt;CustID&gt;Cust1234&lt;/CustID&gt;
    &lt;Name&gt;Smith&lt;/Name&gt;
    &lt;City&gt;New York&lt;/City&gt;
    &lt;Orders&gt;
      &lt;order Orderid="101"&gt;
        &lt;Product&gt;MP3 Player&lt;/Product&gt;
      &lt;/order&gt;
      &lt;order Orderid="102"&gt;
        &lt;Product&gt;Radio&lt;/Product&gt;
      &lt;/order&gt;
    &lt;/Orders&gt;
  &lt;/xa:MeContext&gt;
  </code></pre>
  
  <p>This well formed XML document feeds to Excel 2007 using MS VBA code.  I was successful 
  with using <code>DOMDocument</code> and <code>IXMLDOMElement</code> to import the Name, City, and Product.<br>
  However, the <code>xa:MeContext id</code>, <code>vsData1 id</code>, <code>VsData2 id</code>, <code>CustID</code>, and <code>order Orderid</code> number won't export to Excel sheet.  </p>
  
  <p>Each Excel row has the following headers with data filled from XML document:</p>
  
  <pre><code>MeContextID--vsData1--VsData2--CustID--Name--City--OrderID--Product--OrderID--Product
  </code></pre>