|
我在别人写好的代码里面改为我想要的地址。为什么总在Set tb = HTML.ALL.tags("table")(0).Rows 出错。 请哪位高人指点一下。
另外我有一个网站登陆后被网站被加密了,是否有办法抓取上面的信息。也请高手指点一下。谢谢
- 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", "网址& 30 * 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
|
|