以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 关于从网址取数据 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=150649) |
-- 作者:做自己 -- 发布时间:2020/6/3 20:37:00 -- 关于从网址取数据 Dim XMLH As Object XMLH = CreateObject("Microsoft.XMLHTTP") XMLH.open("GET", "https://www.opencai.net/open.html", True) \'获得实时信息 XMLH.send(Nothing) Do While XMLH.readyState <> 4 Application.DoEvents Loop \'把数据json数据转化成对象 Dim json As String = XMLH.responseText Dim ScriptControl As Object, data2 As Object, JscriptCode As String JscriptCode = "function toObject(json) {eval(""var o= "" + json);return o;} " ScriptControl = CreateObject("MSScriptControl.ScriptControl") ScriptControl .Language = "Javascript" ScriptControl .Timeout = -1 ScriptControl .AddCode(JscriptCode) data2 = ScriptControl .Run("toObject", json) 最后一句这里我直接调用就提示语法错误怎么回事
|
-- 作者:有点蓝 -- 发布时间:2020/6/4 8:06:00 -- 调用接口请使用HttpClient:http://www.foxtable.com/mobilehelp/topics/0246.htm |