(Excel) JSON UpdateString

Demonstrates the JSON object's UpdateString method.

Note: The UpdateString method was introduced in Chilkat v9.5.0.63

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires Chilkat v9.5.0.63 or greater.

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

' The UpdateString method updates or adds a string member.
' It also auto-creates the objects and/or arrays that
' are missing.  For example:
Dim success As Boolean
success = json.UpdateString("test.abc[0].xyz","Chicago Cubs")

' The JSON now contains:
Debug.Print json.Emit()

' {
'   "test": {
'     "abc": [
'       {
'         "xyz": "Chicago Cubs"
'       }
'     ]
'   }

success = json.UpdateString("test.abc[0].xyz","Chicago Cubs are going to win the World Series!")
Debug.Print json.Emit()

' {
'   "test": {
'     "abc": [
'       {
'         "xyz": "Chicago Cubs are going to win the World Series!"
'       }
'     ]
'   }