|
楼主 |
发表于 2016-8-9 09:20
|
显示全部楼层
Excel学徒123 发表于 2016-8-8 17:47
问题一大堆
你好这个是用VB抓取网页的数据生成excel表格。你能帮助理解一下下面的编码?有些我可以看懂有些我看不动~~请帮助谢谢!
尤其是对下面绿色部分的理解!!非常感激!
Option Explicit
Sub test()
Dim HTML, tb, i&, j&, x&, n&, s$
[a2:d9999] = ""
Set HTML = CreateObject("htmlfile")
With CreateObject("msxml2.xmlhttp")
For x = 0 To 63
.Open "get", "http:(增加双//)fz.people.com.cn/skygb/sk/index.php/Index/seach?&p=1
& 20 * x, False
.Send
Application.Wait (Now + TimeValue("00:00:02"))
HTML.body.innerhtml = .responsetext
Set tb = HTML.ALL.tags("table")(0).Rows
For i = 1 To tb.Length - 1
n = n + 1
For j = 0 To tb(i).Cells.Length - 1
Cells(n + 1, j + 1) = tb(i).Cells(j).innertext
Next
Next
Next
End With
MsgBox
End Sub
|
|
|