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

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

by | Jun 11, 2017 | JSON, VBA

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

by | Nov 22, 2015 | C#, VBA

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()

by | Jul 2, 2015 | VBA

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

by | May 20, 2015 | MS Access, VBA

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

by | May 18, 2015 | VBA

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...