vba scrape non-static web table data
<p>I'm trying to create a macro that scrape and import tables from a <a href="http://www.neeq.com.cn/static/statisticdata.html" rel="nofollow">web page</a>, 
More specifically, I want to get two tables<a href="http://i.stack.imgur.com/jQTYo.jpg" rel="nofollow">tables pointed by arrows, please ignore the text in the table if it doesn't make sense, I translated using google</a>. These tables are updated automatically so I used IE approach(by @ron), didn't scrape any data. I'm exhausted, can anyone please help me? I'm a vba newbie, appreciate any help.</p>

<pre><code>    Sub test()
    ' open IE, navigate to the website of interest and loop until fully loaded
      Set IE = CreateObject("InternetExplorer.Application")
      my_url = "http://www.neeq.com.cn/static/statisticdata.html"

    With IE
       .Visible = False
       .navigate my_url
       .Top = 50
       .Left = 530
       .Height = 400
       .Width = 400

    Do Until Not IE.busy And IE.ReadyState = 4
       DoEvents
    Loop

   End With

  Set tbl = IE.Document.getElementsByTagName("table")
    For Each itm In tbl
         i = 1
        For Each itm2 In itm.Rows
            For Each cell In itm2.Cells
              ActiveSheet.Cells(i, 2) = cell.innerText
              i = i + 1
            Next
        Next
   Next
  end sub()
</code></pre>