Access/VBA Library

JSON functions

A collection of functions to convert VBA data to JSON format.

Module: mdlJSON

Remarks

  • I use these functions for representing VBA data by HTML and javascript.
  • Take a look at my JSONparser class for parsing JSON data structures.

See also

  • JSONParser
Example
' Create JSON array and store it as a Javascript variable
Dim fs As New FileSystemObject
With fs.CreateTextFile("C:\employees.js", True)
   .Write "var employees = " & QueryToJSON( "employee" ) & ";"
   .Close
End With'

Changelog

Date Changes
2017-10-20 Function StringToJSON added for String-conversions.

Topics