I need to convert 2,000-10,000 name:value pairs of data from excel sheets into JSON format.
The data is not in a regulate tabular structure, and will be written to the spreadsheet in a layout that I can define.
The maximum 'depth' of recursion within the string is about 10.
My data DOES form a functional JSON string (when created via a method that cant be transferred to Excel).
Processing speed is not an issue.
I write vba; some practical experience of classes.
I seek pointers to established methods that can be run in excel, or in association with excel, preferably on the WEB.