title: Dynamically search for data In an XML file with VBA
body: <p>I need to open up an XML file in the VBA in Excel. There are two strings of data I'm look for in the XML file that are under are a Tag. these strings can be found under multiple tags though, I also need concatenate them.  </p>
  
  <pre><code>&lt;Systems&gt;
    &lt;conveyor ConveyorNumber="132000"&gt;
      &lt;conveyor&gt;132000&lt;/conveyor&gt;
      &lt;productName&gt;IQ&lt;/productName&gt;
    &lt;/conveyor&gt;
  &lt;/Systems&gt;
  </code></pre>
  
  <p>There's more data in there, but I only need </p>
  
  <pre><code>&lt;conveyor&gt;132000&lt;/conveyor&gt;  
  </code></pre>
  
  <p>&amp;</p>
  
  <pre><code>&lt;productName&gt;IQ&lt;/productName&gt;
  </code></pre>
  
  <p>. There are multiple </p>
  
  <pre><code>&lt;Systems&gt;&lt;/Systems&gt;
  </code></pre>
  
  <p>in the file, so I need count the Systems in the file concatenate the two strings needed and place all of them in a column in an Excel sheet. Is there anyway to do this?</p>