get list of custom procedures

a_southwould

New member
Local time
Today, 10:40
Joined
May 12, 2004
Messages
4
I am looking for a way to dynamically "browse" a list of public subs/functions in a user created module within a database. I do not want the procedure's code, just it's name. It would be a bonus to get the parameters and return value, but this is not a necessity.

Previously, I have been referencing a Module from Database.Containers("modules").Documents() then looping through lines of the module using ProcOfLine, ProcBodyLine, Lines, etc. and gathering the procedure names.

This is kind of a pain, but it works. However, I now need the ability to do this with an MDE as well as an MDB. Since the MDE's are compiled, modules are not available for this action.

If I add the MDE as a reference to a VB project or an MDB, and open the object browser, I am able to see the list of procedures. I understand this browser object is based on the tblinf32.dll and have been trying to pull that information using these functions. I am able to programatically get a reference to the MDE that will allow me to view the standards objects with their properties and methods. I have been unable to view modules and what I really need - the functions within those modules.

Any help would be greatly appreciated.

My application is written in VB6 and using automation to communicate with the user's database.

Thanks, Lynn
 

Users who are viewing this thread

Back
Top Bottom