|
楼主 |
发表于 2017-8-3 09:38
|
显示全部楼层
本帖最后由 staynam 于 2017-8-3 09:40 编辑
大大您好,您之前给的代码突然不能用了,但是我用httpfox嗅探地址发现真实地址并未改变,跪求帮忙。
运行的时候出现如下错误
然后点击调试会跳到 .send 这一行
跪求大大帮忙
其中一个代码如下(因为论坛等级不能发链接,所以我把 url= 后面的 http:// 去掉了)
- Sub test_1()
- Dim url$, strJSON$, objJson, rData
- Dim ar, brr(1000, 30), i%, j%
- url = "fund.eastmoney.com/data/rankhandler.aspx?op=ph&dt=kf&ft=qdii&rs=&gs=0&sc=1yzf&st=desc&qdii=&tabSubtype=,,,,,&pi=1&pn=51"
- With CreateObject("msxml2.xmlhttp")
- .Open "GET", url, False
- .send
- strJSON = .responsetext
- End With
- With CreateObject("msscriptcontrol.scriptcontrol")
- .Language = "JavaScript"
- .AddCode strJSON
- Set objJson = .CodeObject
- End With
- For Each rData In objJson.rankData.datas
- i = i + 1
- ar = Split(rData, ",")
- For j = 0 To UBound(ar)
- brr(i, j) = ar(j)
- Next
- Next
- Cells.Clear
- Cells.Font.Size = 9
- [a:a].NumberFormatLocal = "@"
- [a1].Resize(i, UBound(ar)) = brr
- MsgBox "抓取完毕!"
- End Sub
复制代码
|
|