View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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