All Questions
Tagged with meta-programming vba
4 questions
28
votes
5
answers
4k
views
Automagic testing framework for VBA
Building on @RubberDuck's recommendations, I now have something I find... beautiful. I'm sure there's a couple of things left to polish - this site is about making great code out of good any code, ...
- 75.1k
12
votes
1
answer
5k
views
Extending the VBA Extensibility Library
The Microsoft Visual Basic for Applications Extensibility library let's us meta-program VBA, but the way it handles (or rather, doesn't handle) getting to the actual subs and functions is clunky at ...
- 30.9k
11
votes
2
answers
1k
views
Generating and calling code on the fly
Delegate
This class module defines what I'm calling, in this context, a Delegate - here a function that can take a number of parameters, evaluate a result, and ...
- 75.1k
9
votes
3
answers
1k
views
Ugly workaround to get the vbext_ProcKind of a procedure is breaking encapsulation
This is a follow up to Extending the VBAExtensibility Library. It turns out that code had a really nasty bug. Anytime vbeProcedure.StartLine got called, I was ...
- 30.9k