There is plenty of reference information cJobject on this site, starting with How to use cJobject, or just enter cJobject in the search box. Here's a quick reminder of what you'll need to understand to follow this app example.
What is cJobjectIt's an attempt to emulate a JavaScript object within the limits of VBA syntax. It's fully recursive, so you can have endless parents and children depth, can handle arrays, and knows how to Parse JSON, and how to create it. I use it in almost everything I do in VBA - The great thing for me is to be able to 'create classes on the fly' with dynamic properties, which is exactly what we need to be able to parameterize VBA applications.
As a reminder here's a cJobject slide primer
Some examplesHere's how it looks against the equivalent JavaScript using a few common things you need to do. Since we are creating classes on the fly at run time, the syntax of VBA makes it a little more wordy, but it achieves approximately the same thing. There are a few useful things exposed also that don't exist in javaScript
Complete list of cJobject methods and propertiesYou can get me on Google plus, Twitter or this forum.
|
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > excel to json and back > Data driven VBA apps with JSON >