title: Excel VBA Extracting Inner Text from href Tag
body: <p>the HTML CODE look like this:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;div class="WebPageMessage"&gt;
  &lt;div class="WebPageMessageInformation"&gt;
  &lt;div class="Message"&gt;Your request has been scheduled. &lt;a href="/MyAccount/QueuedJob.aspx?JobID=221816"&gt;Job # 221816. Click here To monitor Schedule&lt;/a&gt;&lt;br&gt;There are 0 job(s) already in the queue.&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>Desired result: Extract the text "Job # 221816..."</p>
  
  <p>here is the code im trying to use but i am getting "object is no supported" error msg
  <code>Set foo = objIE.document.getElementsByClassName("Message").getElementsByTagName("a").innerText</code></p>
  
  <p>Any help would be great
  Thanks and happy holidays : )</p>