VBA JSON Parser Backus-Naur Form JSON Parser based on RegEx for VBA. Purpose and Features Parsing JSON string to a structure of nested Dictionaries and Arrays. JSON Objects {} are represented by Dictionaries, providing .Count , .Exists() , .Item() , .Items , .Keys properties and methods. JSON Arrays [] are the conventional zero-based VB Arrays, so UBound() + 1 allows to get the number of elements. Such approach makes easy and straightforward access to structure elements (parsing result is returned via variable passed by ref to sub, so that both an array and a dictionary object can be returned). Serializing JSON structure with beautification. Building 2D Array based on table-like JSON structure. Flattening and unflattening JSON structure. Serializing JSON structure into YAML format string. Parser complies with JSON Standard . ...