title: Parsing xml/html like text file with VBA macro
body: <p>I have some raw data output in a text file from a program that I need to store and then format. The file output looks as such:</p>
  
  <pre><code>&lt;Request&gt;
      &lt;code_set&gt;1604&lt;/code_set&gt;
      &lt;start_code_value&gt;-1&lt;/start_code_value&gt;
      &lt;block_size&gt;10000&lt;/block_size&gt;
      &lt;ignore_access_ind&gt;0&lt;/ignore_access_ind&gt;
  &lt;/Request&gt;
  </code></pre>
  
  <p>All of the data is stored in Request or Reply block</p>
  
  <p>All data is on a <strong><em>single row</em></strong> of the text file</p>
  
  <p>Each request/reply block has many sub blocks - this is conditional; there could be 1, there could be 1,000</p>
  
  <p>The data within the block is also conditional - there may be data and there may not be</p>
  
  <p>I need to parse this out so in column A of an excel sheet it reads the name of the sub-block and column B has the data (if any). </p>