|
本帖最后由 爱疯 于 2013-7-17 23:21 编辑
学习找,找不着83,我也是像楼上这么除来的
- Sub test()
- Dim A, B, i, n
- '求记录总数
- With CreateObject("MSXML2.XMLHTTP.3.0")
- .Open "GET", "http://quote.stockstar.com/stock/ranklist_a_3_1_1.html", False
- .send
- A = Split(.responseText, Chr(10))
- For i = 0 To UBound(A)
- If InStr(A(i), "记录总数") Then Exit For
- Next i
- End With
- B = Split(A(i + 1), """")
- n = B(UBound(B) - 1)
-
- '页数 = 记录总数 / 每页条数
- MsgBox IIf(n \ 30, Int(n / 30) + 1, Int(n / 30))
- End Sub
复制代码 |
|