VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.76k stars 568 forks source link

Doesn't work in access as a udf for sql #164

Closed martingaleh closed 4 years ago

martingaleh commented 4 years ago

`Function jeff(jt As String, key As String) As variant Dim jsonObject As Object Set jsonObject = JsonConverter.ParseJson(jt) Dim k As Variant Dim x As Variant

k = jsonObject(key)
jeff = CStr(jsonObject(key))

End Function`

select jeff("{"""a""":1}","a") won't work. Works fine in immediate window