Can You Read Module Names Using VBA?

[roadkill]

Is there a way to read individual VBA module names (including any user forms)
programmatically?

My basic problem is as follows: I have a set of tools that have been made
available to Project Managers. Whenever a tool is added or an update done on
an existing tool, the PM's can go to the organizer and recopy the tool module
(and sometimes a user form) to their Global file and have all the latest.
I'd like to simplify this by providing a macro that does the update for them.
Unfortunately, if the update code lies in the tool module, I'd be trying to
rewrite the module I'm executing from. One solution would be to put the
update code in a separate module. But I'd need to exclude this module from
the copy (i.e. I want the update code to copy all modules except the one
containing the update code that is running, so that any forms get copied
too). If I can programmatically check the module names, I can make sure and
copy just what should be copied.

So there you have it. Any ideas?

Thanks,
Will

 

[Jan De Messemaeker]

Hi,

To get forms and modules in the global:

for each Modul in vbe.vbprojects(1).vbcomponents
debug.print Modul.name
next

Hope this helps

 

[roadkill]

This looks like it should work. Thank you!

Hi,

To get forms and modules in the global:

for each Modul in vbe.vbprojects(1).vbcomponents
debug.print Modul.name
next

Hope this helps