|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub test()
Dim html, r, p%, i%, j%
Dim objhq As New MSXML2.XMLHTTP
Cells.Clear
With objhq
For p = 1 To 3
.Open "GET", "http://data.eastmoney.com/soft_new/bbsj/201412/yysj/gpdm/" & p & ".html", False
.send
Set html = CreateObject("htmlfile")
html.Body.innerhtml = .responseText
Set r = html.all.tags("table")(0).Rows
For i = 0 To r.Length - 1
For j = 0 To r(i).Cells.Length - 1
Cells((p - 1) * 50 + i + 1, j + 1) = r(i).Cells(j).innertext
Next j
Next i
Next p
End With
End Sub
|
评分
-
1
查看全部评分
-
|