List all modules in workbook X?
The following code will list all the modules in the
ActiveWorkbook. There is no way to determine when a module was
last modifed.
"KR" wrote in message
...
This is probably an easy one, I just don't know the commands to
use- I'm
looping through a series of workbooks, and need to identify the
module names
in each.
If possible, it would be really, really helpful to know when
each module was
last updated- in some cases there are modules with the same
name, some of
which were imported replacements for older (broken) code, so if
I can figure
out which workbooks have that module /and/ which ones are the
old ones that
still need to be replaced, that would be very, very cool.
Thanks for any help or advice,
Keith
|