How can I read JSON code in Visual Basic?

Question

I have JSON data in this form [{"word":"something", "id":1023] How can I get the value of word from the JSON data using Visual Basic? Thanks.

Use a JSON parser - Tim Hall wrote a pretty nice one, it's on GitHub — Mathieu Guindon
– Mathieu Guindon, Commented Jan 10, 2019 at 19:52

Ryan Wildry · Accepted Answer · 2019-01-10 20:02:56Z

1

Grab a copy of this project, add it to your VBA project. You'll need to add a reference to Microsoft Scripting Runtime for this to work as the results from the parsed string get stored in a Dictionary. Once that's done, you can parse JSON, like this:

Sub ParseSomeJson()
    Dim jsonString As String
    Dim json As Object
    jsonString = "{""word"":""something"", ""id"":1023}" 'I adjusted this 
    Set json = JsonConverter.ParseJson(jsonString)
    Debug.Print json("word"), json("id")
End Sub

You'll get back:

something      1023

answered Jan 10, 2019 at 20:02

Ryan Wildry

5,6971 gold badge17 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mathieu Guindon Over a year ago

Note that Tim Hall also wrote a drop-in replacement for Scripting.Dictionary (also found under that VBA-TOOLS GitHub org), that works off the Scripting Runtime on Windows, and works on a Mac.

Collectives™ on Stack Overflow

How can I read JSON code in Visual Basic?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related