Released earlier this year, ModernJsonInVBA parses JSON and writes it straight into Excel tables (ListObjects), and converts tables back to JSON roundtrip. It is pure VBA: no Scripting.Dictionary, no COM references, no external libraries. One call turns JSON text to a populated, refreshable table:

Excel_UpsertListObjectFromJsonAtRoot ws, "tOrders", ws.Range("A1"), jsonText, "$"

v3.0.0 split the engine into eleven modules and rewrote the parser and the Excel write path. I benchmarked it across seven payloads that vary in size and shape (flat rows, nested objects, escape-heavy strings, a 200-column wide table, numeric-heavy) and collected the results into a matrix.

Payloads

Timings (seconds) — rows are pipeline steps, columns are payloads:

What the matrix shows:

• 500,000 rows / 110 MB of JSON into a live Excel table in about 18 seconds (Upsert create). That is roughly 27,000 rows/sec, or ~275,000 cells/sec.
• Small payloads are effectively instant: 10,000 rows loads in about a third of a second.
• A raw block write of 5 million cells takes only a few seconds; most of the 18 s is parsing and shaping the JSON.
• Upsert streams JSON straight into a 2D array for a root array (tableRoot = "$") and does not build an intermediate object model, so it keeps pace with a standalone parse plus a sheet write.

The benchmark machine is a Ryzen 7 9800X3D with 64-bit Excel, each cell is one wall-clock Timer run, and the payloads come from a seeded generator (deterministic). Times are hardware-dependent, so a typical office laptop will be slower. The whole table regenerates from the workbook with one macro (Run_JsonPerfMatrix), so you can produce your own numbers.

The library also does CSV and XML to JSON, JSONPath-style path resolution, schema evolution controls, and formula-preserving refreshes. Determinism is the design goal: stable column order, strict validation, and clear error numbers instead of silent guesses.

Repo (MIT): https://github.com/WilliamSmithEdward/ModernJsonInVBA

https://github.com/WilliamSmithEdward/ModernJsonInVBA/releases/tag/v3.0.0

Feedback is welcome.

pyVBAReference: static VBA / Office COM reference data

I built pyVBAReference, a Python package that extracts and ships VBA / Office COM reference data in tool-friendly formats.

The output includes:

• JSON reference files
• generated Markdown docs
• a Python lookup API
• a small CLI

The main use case is external tooling.

For example:

lookup Worksheet members
resolve method/property/event metadata
inspect parameters
find enum values
index Office object models
ground autocomplete or hover docs
support editor / LSP experiments

VBA has a lot of reference data available through COM type libraries and the Object Browser, but it is not especially convenient to consume outside the VBA IDE.

This repo is an attempt to make that data easier to query from Python and other tooling.

Repo:

https://github.com/WilliamSmithEdward/pyVBAReference

Hello VBA community,

I built XLIDE, an MIT licensed open source VS Code extension for editing Excel VBA directly from .xlsm files.

You can open a workbook, browse its VBA modules, edit code in VS Code, use Go to Definition / Find References / Rename Symbol, and save changes back with Ctrl+S.

The read/write path does not use COM, Office automation, or win32com (quick shortcuts to open workbooks / run macros with F5 with COM are available though). It uses a Python backend with pyOpenVBA. It reads and writes directly to the VBA source package.

I also confirmed it works with VS Code Live Share, so two people can review or pair on workbook VBA without screen-sharing the VBE.

The other exciting part: XLIDE exposes workbook and VBA operations to Copilot agent tools. So an agent can list modules, read modules, inspect subs, read/write cells, export modules, and write changes back, with confirmation on write operations.

Many other features are also implemented.

Marketplace:
https://marketplace.visualstudio.com/items?itemName=WilliamSmithE.xlide

GitHub:
https://github.com/WilliamSmithEdward/xlide_vscode

Would love feedback from people who maintain VBA projects.