VBA JSON Parser[z]

Http://www.ediy.co.nz/vbjson-json-parser-library-in-vb6-xidc55680.html

Vb-json:a Visual Basic 6 (VB6) JSON Parser Class Library 66

Introduction to JSON for Visual Basic 6
Vb-json is a Visual Basic 6 class library for parsing and emitting JSON (Javascript Object Notation) and can handle nested Arrays and objects in the data. It does not rely on the JScript engine for parsing.

JSON is a useful and compact format for data interchange between a browser based JavaScript client program and a VB6 based Data server, and also for storing structured meta data in a text field.  It can also be used as a efficient RPC transport protocol and compresses well using GZIP. The project also includes a fast string builder class for assembling, the JSON data string at a.

This software is the BSD licenced and is based on a Excel macro found here. Some parsing bugs in the original functions has been fixed and the String builder class improves performance. Also There is some handy utility functions that return a JSON data set from an ADO Recordset or a character delimited str Ing.

Vbjson Download
Download the Vb-json JSON Parser class and a simple example project from here:

Download Vbjson.zip

Release history
18th April: Initial Release
23rd April: Added JSON file Parser button to the sample project and a simple error list to show parsing errors rather than using Err.Raise
26th April:
* Improved JSON parser error handling
* Added//And/* * * Comment support
* Added an early implementation of a simple scripting system called Jsonscript

18th July:
* Changed Vbjson.cls to Json.bas Module to make it a singleton
* Fixed a bug with data containing the/character
* Changed FormatNumber function to use Long integers
* Added code for making JSON-RPC calls

1 August 2010
* Fixed a bug in the JSON parser that hangs to a colon character in a key.

2012 March
* Thank Hynek C for a patch to fix a possible infinite loop in the Array/object parser. Please update the Json.bas module file in your existing projects.

2012
* Thanks to Nick P for pointing out, that clng/val are not the best number conversion function for large numbers. The project has been updated to use the CDEC function instead.

A Contact e-mail address is given in the header of the class if you find any bugs or has suggestions on what to improve thi S project.

For more information on the uses of JSON and the data format, please refer to the json.org Web site.

Our internal use of JSON have increased not at the Ediy web design and ecommerce software, but also some embedded MICR Ocontroller projects because it's so compact, yet able to encode complex data in very few bytes!

VBA JSON Parser[z]