If you’re like me, you might have hundreds, or even thousands of databases and finding VBA code, know what is where might be a challenge to put things lightly.
In the past I provided a procedure to get some information about modules and procedures:
VBA - VBE Enumerate Modules, Procedures and Line Count
It still amazes me how Microsoft can develop these complexe applications but seems to overlook some simple functions that they should included within them to aid developers… But then, as demonstrated with the release of Office 2007 and 2010, Microsoft is not interested in the developer, they are only interested in the end-user’s opinion. Not…
Continue reading →
I thought I’d share a slightly modified version . The reason this one can be useful is because you can actually use it to pull information for external databases, not just the current database. I use this type of approach to create an inventory of modules/functions making it much easier to locate things in amongst all my databases, workbooks & documents.
It extracts a list of modules with your VBE projects and further enumerate the various procedures within each module providing information about the name, type, no lines of code, …
Continue reading →
