Is There a JSON Parser for VB6 / VBA?

by

Check out JSON.org for an up-to-date list (see bottom of main page) of JSON parsers in many different languages. As of the time of this writing, you’ll see a link to several different JSON parsers there, but only one is for VB6/VBA (the others are .NET):

  • VB-JSON

    • When I tried to download the zip file, Windows said the data was corrupt. However, I was able to use 7-zip to pull the files out. It turns out that the main “folder” in the zip file isn’t recognized as a folder by Windows, by 7-zip can see the contents of that main “folder,” so you can open that up and then extract the files accordingly.

    • The actual syntax for this VB JSON library is really simple:

      Dim p As Object
Set p = JSON.parse(strFormattedJSON)

'Print the text of a nested property '
Debug.Print p.Item("AddressClassification").Item("Description")

'Print the text of a property within an array '
Debug.Print p.Item("Candidates")(4).Item("ZipCode")
    • Note: I had to add the “Microsoft Scripting Runtime” and “Microsoft ActiveX Data Objects 2.8” library as references via Tools > References in the VBA editor.
    • Note: VBJSON code is actually based on a google code project vba-json. However, VBJSON promises several bug fixes from the original version.

More Related Contents:

  1. How do I upload a file with metadata using a REST web service?
  2. JSON character encoding – is UTF-8 well-supported by browsers or should I use numeric escape sequences?
  3. How to consume a web service from VB6?
  4. Spring, Jackson and Customization (e.g. CustomDeserializer)
  5. Load data from Webservice (asmx) to jqgrid. Please help me
  6. Maximum length of HTTP GET request
  7. Cannot deserialize the JSON array (e.g. [1,2,3]) into type ‘ ‘ because type requires JSON object (e.g. {“name”:”value”}) to deserialize correctly
  8. Getting ServiceStack to retain type information
  9. Json.net serialize/deserialize derived types?
  10. Stringify (convert to JSON) a JavaScript object with circular reference
  11. Json.Net: Serialize/Deserialize property as a value, not as an object
  12. How to serialize/deserialize a custom collection with additional properties using Json.Net
  13. Custom Deserialization using Json.NET
  14. How can I serialize and deserialize a type with a string member that contains “raw” JSON, without escaping the JSON in the process
  15. Force JSON.NET to include milliseconds when serializing DateTime (even if ms component is zero)
  16. Gson Serialize field only if not null or not empty
  17. How can I verify a Google authentication API access token?
  18. In Excel VBA on Windows, for parsed JSON variables what is this JScriptTypeInfo anyway?
  19. Best way to call a JSON WebService from a .NET Console
  20. Implementing String.Format() in VB6
  21. Serializing an interface/abstract object using NewtonSoft.JSON
  22. object to deserialize has a C# keyword
  23. JSonNet boolean serialization
  24. Why do ASP.NET JSON web services return the result in ‘d’?
  25. What is the difference between a web API and a web service?
  26. Parsing a complex Json Object using GSON in Java
  27. ASP.NET WebService is Wrapping my JSON response with XML tags
  28. Jackson Serialize Instant to Nanosecond Issue
  29. Using VBA and VBA-JSON to access JSON data from WordPress API
  30. Jackson deserialize based on type

Leave a Comment