title: Excel VBA web scraping from table
body: <p>I am trying to extract some info from the table below into Excel using VBL without any success. The values which I need do not seem to have any element ID, tag name or class name assigned to it.  I'm after the Fuel Usage value(89218) and the time value in the same row (01:15). Can anyone point me in the right direction on how to scrape values from a table, or how to extract data from specific TR, TD.</p>
  
  <p>HTML source of the table:</p>
  
  <pre><code>&lt;h3&gt;Airbus A300-600-PW4158 Fuel Planner&lt;/h3&gt;
  &lt;p&gt;London to Chicago  EGKK-KORD (3441 NM)&lt;br /&gt;&lt;/p&gt;
  &lt;h2&gt;Total Fuel: 101901 POUNDS&lt;/h2&gt;
  &lt;table width="100%" border=1&gt;
      &lt;tr&gt;
          &lt;th style="text-align:left;"&gt;&amp;nbsp;&lt;/th&gt;
          &lt;th style="text-align:left;"&gt;Fuel&lt;/td&gt;
          &lt;th style="text-align:left;"&gt;Time&lt;/th&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
          &lt;td&gt;Fuel Usage&lt;/td&gt;
          &lt;td&gt;89218&lt;/td&gt;
          &lt;td&gt;08:47&lt;/td&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
          &lt;td&gt;Reserve Fuel&lt;/td&gt;
          &lt;td&gt;12682&lt;/td&gt;
          &lt;td&gt;01:15&lt;/td&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
          &lt;td&gt;Fuel on Board&lt;/td&gt;
          &lt;td&gt;101901&lt;/td&gt;
          &lt;td&gt;10:02&lt;/td&gt;
      &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>much appreciated.</p>