You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
But I kept getting errors involving this line of the JsonConverter Module:
json_ParseObject.Item(json_Key) = json_ParseValue(json_String, json_Index)
Its saying Run-Time error'0':
KeyNotFoundError
Dictionary key not found :id
This is the code i'm trying to run:
Sub testJson()
Dim jsontext As String
Dim productObject As Object
jsontext = "{'id':'p01','name':'name 1','price':4.5,'quantity':20}"
Debug.Print jsontext
Set productObject = JsonConverter.ParseJson(jsontext)
Debug.Print productObject("id")
End Sub
I have the MS Scripting Runtime checked in my references.
Do I have something misspelled?
The text was updated successfully, but these errors were encountered:
I was following RedStapler's guide here: https://www.youtube.com/watch?v=CFFLRmHsEAs
But I kept getting errors involving this line of the JsonConverter Module:
json_ParseObject.Item(json_Key) = json_ParseValue(json_String, json_Index)
Its saying Run-Time error'0':
KeyNotFoundError
Dictionary key not found :id
This is the code i'm trying to run:
Sub testJson()
Dim jsontext As String
Dim productObject As Object
jsontext = "{'id':'p01','name':'name 1','price':4.5,'quantity':20}"
Debug.Print jsontext
Set productObject = JsonConverter.ParseJson(jsontext)
Debug.Print productObject("id")
End Sub
I have the MS Scripting Runtime checked in my references.
Do I have something misspelled?
The text was updated successfully, but these errors were encountered: