title: VBA to Capture text between Tags
body: <p>I am trying to extract data from a website using VBA in excel. 
  The page source has the following (below), and I can extract the text "This is my text" which is between the "A" tags, and I can extract everything that is between the "DIV" tags, which displays as " This is my text (XXXXX)" .....but I am unable to extract the block of text that just appears after the "/A"...eg "(XXXXX)"</p>
  
  <pre><code> &lt;div style="padding: 1px;"&gt;&lt;a href="#" onclick="if(typeof jsfcljs == 'function'){jsfcljs(document.getElementById('MainPage'),{'j_id32'},'');}return false"&gt;This is my text&lt;/a&gt; (XXXXX)&lt;/div&gt;
  
  &lt;div style="padding: 1px; padding-left:20px;"&gt;&lt;a href="#" onclick="if(typeof jsfcljs == 'function'){jsfcljs(document.getElementById('MainPage'),{'j_id32'},'');}return false"&gt;This is my text&lt;/a&gt; (XXXXXXXX)&lt;/DIV&gt;
  </code></pre>
  
  <p>Any ideas??</p>