find names of routine in modules in many workbooks

[Guest]

I've been assigned the task to modify a routine in possibly hundreds of
workbooks.

I need to open each workbook, enter vb, look thru each module for the
routine I need to modify.

Is there a way to search each module in a project and extract the name of
each routine name (sub doSomething())?

Thanks

 

[Guest]

Hi Mike, I have never tried getting into it, but the declarations tab in the
VB editor has a list of all the procedures in that module. So, there must be
a way to get to it and query for a procedure name. Maybe one of the MVP guys
will give some insight on it.

 

[Ron de Bruin]

hi Mike

Here is code to loop through the workbooks
http://www.rondebruin.nl/copy4.htm
You can replace the "change/Copy" code to your code

See this page how you can edit the code
http://www.cpearson.com/excel/vbe.aspx

 

[Guest]

WOW - what a help - works like a champ.

Can't thank you enough.

Mike