extension
JSON

JSONBag

Direct Answer

JSONBag is a JSON library for Microsoft Office automation. Uses shebang notation to extract keys from JSON strings. Can also build JSON with this library. Hosted at vbforums.com.

What it does

Core purpose

Uses shebang notation to extract keys from JSON strings. Can also build JSON with this library.

Where it sits

JSONBag belongs to the JSON family of VBA community tools. It is listed on the community-maintained awesome-vba index and is actively used by Microsoft Office automation developers.

How to get it

Source location

Full source, documentation, and release notes are maintained at vbforums.com. Treat that URL as the canonical reference — bugs and feature requests live there.

Installation pattern

For a typical GitHub-hosted VBA library: download the .bas, .cls, or .frm files from the repository, then in the VBA editor (Alt + F11) use File → Import File… to bring each module into your project. Save the host document as .xlsm, .accdb, or .docm so macros are retained.

When to use it

Best fit

Reach for JSONBag when your automation needs JSON capability and you want a peer-reviewed library rather than rolling your own. The awesome-vba curator reviews inclusions for active maintenance and community support.

Alternatives worth evaluating

Before committing to JSONBag, browse the other entries in the same JSON section of our tools directory — several libraries typically overlap in purpose, and the right pick depends on your Office version, 32- vs 64-bit target, and licensing needs.

Open source

Link goes to the maintainer’s repository; license terms vary per project.


open_in_new
Open on vbforums.com