Set ScriptEngine = CreateObject('MSScriptControl.ScriptControl') 'New ScriptControl

Private ScriptEngine As Object 'ScriptControl (ref: Microsoft Script Control 1.0) Module JsonParser: Option Compare Database Following that is another code example for how to use this.

Toss the following into a standalone module. (credit to StackOverflow member Codo for the original source, as near as I can tell) As well it should, is it’s tapping into the Microsoft JavaScript Engine to do the work. In any case, after numerous hours and at least a dozen different parsers being tested, I found the one that seems to work across the board. Furthermore, there’s a number of other “hand-made” parsers that seem to suffer the same faulty algorithm. The issue seems to be in the parsing algorithm used: some structures of valid JSON raise errors using the above code (see some examples here – and maybe watch the issue to see if there’s a fix at some point?). I used this for a while myself, until I ran into a case that it fails on, which put me back on the drawing board. Tim Hall has a great set of tools in his github repo, one in specific called VBA-JSON that tends to be a first hit when people have to go searching. We work with JSON a fair amount (and honestly I can’t say I care for it too much for anything outside of the JavaScript realm), and when it comes to VBA, there’s next to no support for it.

Excel parse json