|
本帖最后由 ivrdachen 于 2018-3-22 14:09 编辑
找到一段json数据处理的代码,很好用,我想把它变成函数直接调用,总是出错,
Sub bluejson()
Dim aa, y As Object
Set x = CreateObject("ScriptControl"): x.Language = "JScript"
aa = Sheets("Sheet1").Range("A1").Value
Set y = x.eval("eval(" & aa & ")")
MsgBox y.account
End Sub
我想要的函数是
Function bluejson(jsontext) as Object
Dim aa, y As Object
Set x = CreateObject("ScriptControl"): x.Language = "JScript"
aa = jsontext
Set y = x.eval("eval(" & aa & ")")
bluejson=y
End Function
比如json数据是:{"orderID":"06fc55ee-72a6-4f13-d874-d9e137c1e5bc","clOrdID":"","clOrdLinkID":"","account":27874,"timestamp":"2018-03-22T01:36:10.914Z"}
其他过程里面调用
Sub test()
shuju="{""orderID"":""06fc55ee-72a6-4f13-d874-d9e137c1e5bc"",""clOrdID"":"""",""clOrdLinkID"":"""",""account"":27874,""timestamp"":""2018-03-22T01:36:10.914Z""}"
msgbox bluejson.account
End Sub
但报错运行不了,请教下各位该怎么改呢?
|
|