title: Query and parse xml attribute value into XLS using VBA
body: <p>I'm trying to open/load an XML file specified in an Excel worksheet in the range <code>B2</code>. Then, search through a list of XML attributes for <code>name=FUNCTIONAL_ITEM</code> and get all the attribute values after <code>"&gt;</code>.</p>
  
  <p>In the following example, i'd like to extract out the value <code>8</code>, <code>9</code> and <code>10</code>.</p>
  
  <pre><code>&lt;Attribute name="BIN" dataType="String" unit="" multiplier="" tag="LINE,MRPM"&gt;1&lt;/Attribute&gt;
  &lt;Attribute name="FUNCTIONAL_ITEM" dataType="Double" unit="" multiplier="" tag="LINE,LINE DB"&gt;8&lt;/Attribute&gt;
  &lt;Attribute name="FUNCTIONAL_ITEM" dataType="Double" unit="" multiplier="" tag="LINE,LINE DB"&gt;9&lt;/Attribute&gt;
  &lt;Attribute name="FUNCTIONAL_ITEM" dataType="Double" unit="" multiplier="" tag="LINE,LINE DB"&gt;10&lt;/Attribute&gt;
  </code></pre>
  
  <p>Could someone please point me in the right direction for implementing this.</p>