Access – VBE – Retrieve Procedure Text
Here’s a bit of an odd ball, but I was helping out in a forum discussion in which the user needed to be able to display the code behind procedures. He was trying to create some type of teaching tool. Now there are different ways to approach such a thing and he could have copy/pasted each procedure into a table, but that creates duplication (which is never a good thing), creates maintenance since he’ll have to update entries as code is change, … I found the question intriguing and set out to find a way to simply read the information from the VBA project. Anyone have a solution already?