Hi Paul,
I need to convert the json string to vba array...
{"General":{"Brand":["A-DATA""ZTE","ZyXel"],"Model":"","Type":["Cables","Routers","Switches","Data
cards","Access Points","Projector Servers","Internal Modems","Wireless USB
Adapters","Network Interface Cards","Range Extender & Repeate
*thanks Paul, really appreciate *
On Tue, Apr 22, 2014 at 4:59 PM, Paul Schreiner wrote:
> I would probably split the array and do something like:
>
> Sub json_2_Array()
> Dim Array1, Array2, sArray
> Dim inx1, inx2, i
> Dim jSon
> jSon =
> "[[""A"",""string"",0,""NULL""],[""B"",
I would probably split the array and do something like:
Sub json_2_Array()
Dim Array1, Array2, sArray
Dim inx1, inx2, i
Dim jSon
jSon =
"[[""A"",""string"",0,""NULL""],[""B"",""string"",0,""NULL""],[""C"",""string"",0,""NULL""],[""D"",""string"",0,""NULL""],[""E"",""string"",0,""
