How to Parse JSON with VBA (MS Access/Excel)

How to Parse JSON with VBA (MS Access/Excel)

We work with JSON a fair amount (and honestly I can’t say I care for it too much for anything outside of the JavaScript realm), and when it comes to VBA, there’s next to no support for it. Tim Hall has a great set of tools in his github repo, one in...

.NET COM Interop

Mostly as notes to myself, I’m posting my general practices for COM interop. General notes: 1) Create VS Solution with (typically) two or more projects: one for the actual .NET stuff, another to act specifically as the COM interface. Core logic, etc stays in the...

NotImplemented()

I’ve been using this for the past few months, and I love it… thought I’d share, never really seen it done in VBA before (but maybe many of you do anyway and I just don’t know it!). Visual Studio (2012+ I think), automatically puts a throw new...

Generalizing Form Behavior – Refined

In a previous post I tossed out a concept for a global form handler that could be used to generalize form behavior without having to add any code to forms. After having played with it a few days and hashed a few things around, here’s a refined version of actual...

Generalizing Form Behavior

Edit: This post provides the overall concept but not a working code set. I’ve left this post in place and added a new post that contains working code, see here: Generalizing Form Behavior – Refined I have a lot of functionality for forms that I want repeated...