title: Fetch specific table only from website into Excel
body: <p>I need to fetch the table from <a href="http://www.zillow.com/homes/comps/67083361_zpid/" rel="nofollow">http://www.zillow.com/homes/comps/67083361_zpid/</a> into Excel using VBA. I just want the table, nothing else. But when I'm using: </p>
  
  <pre><code>Set objIE = CreateObject("InternetExplorer.Application")
  
  With objIE
      .Visible = True
      .Navigate "http://www.zillow.com/homes/comps/67083361_zpid/"
      Do While .ReadyState &lt;&gt; 4: DoEvents: Loop
      Debug.Print .document.Body.outerText
  End With
  </code></pre>
  
  <p>it gives me text like:</p>
  
  <blockquote>
    <p>4723 N 63rd Dr$63,50008/17/201241.752,0747,6751972$360.11</p>
  </blockquote>
  
  <p>for each product which I can't analyze and store into different cells of Excel.</p>
  
  <p>So is there a way I can fetch the page data in a manageable way. I am OK if I need to traverse a loop for this. Also I can do additional processing to fill the row data into Excel properly.</p>