这个问题我在全球论坛提问过、但没有解决。期待在国内论坛的老师能帮手解决、谢谢!
问财网址: http://www.iwencai.com/unifiedwap/home/index
VBA代码
Sub West()
Dim result, antistop, Values As Variant, i, j, x, y, cnt
Dim Json As Object
cnt = Range("b1") & ""
antistop = "{""question"":""ROE>20"",""perpage"":" & cnt & ",""page"":9,""secondary_intent"":""stock"",""log_info"":""{\""input_type\"":\""click\""}"",""source"":""Ths_iwencai_Xuangu"",""version"":""2.0"",""query_area"":"""",""block_list"":"""",""add_info"":""{\""urp\"":{\""scene\"":1,\""company\"":1,\""business\"":1},\""contentType\"":\""json\"",\""searchInfo\"":true}""}"
With CreateObject("WinHttp.WinHttpRequest.5.1")
.Open "Post", "http://x.10jqka.com.cn/customized/chart/get-robot-data", False
.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36"
.setRequestHeader "Content-Type", "application/json"
.send antistop
result = Split(Split(.responsetext, """datas"":")(1), ",""meta")(0)
Set Json = JsonConverter.ParseJson(result)
End Sub |