VBA- json

[ericlch16]

Hello

i have a complicated json with a lot of nested collection of dictionaries. I did the inside one. but in the final step , i need to convert this FROM

dim myvarDictionary as Dictionary
dim myvarCollection as Collection

myvarDictionary=
{
<dictionary>
}

TO

myvarCollection=
{
"MyName" : [
{
<dictionary>
}
]
}

i tried

myvarCollection.Add "MyName" myvarDictionary

but it is not working. What i am doing wrong ?

 

[Edgar_]

The library has a ParseJson method to convert a JSON string into a VBA object.

dim myvarDictionary as Dictionary
set myvarDictionary = ParseJson({Object})

dim myvarCollection as Collection
set myvarCollection = ParseJson([Collection])

This string represents an object containing a MyName property, which holds a collection of objects as its value:

{
"MyName" : [
{
<dictionary>
}
]
}