|
楼主 |
发表于 2017-6-6 16:08
|
显示全部楼层
本帖最后由 staynam 于 2017-6-6 16:21 编辑
万分感谢!
我试一下
更新,我按照您最开始的代码和后来给的综合了一下,但是好像有问题
- Sub test_XWZ()
- Dim url$, strJSON$, objJson, rData
- Dim sd$, ed$, ar, brr(1000, 30), i%, j%
- ed = Date
- sd = DateAdd("m", -6, Date)
- url = "fund.eastmoney.com/data/rankhandler.aspx?op=dy&dt=kf&ft=etf&rs=&gs=0&sc=qjzf&st=desc&sd=" & sd & "&ed=" & ed & "&es=0&qdii=&pi=1&pn=50&dx=0"
- 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
复制代码
点击调试,自动跳转的是这一行 .Open "GET", url, False
|
|