find names of routine in modules in many workbooks
 

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
--
Mike

find names of routine in modules in many workbooks
 

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.

"Mike Molyneaux" wrote:

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
--
Mike

find names of routine in modules in many workbooks
 

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mike Molyneaux" wrote in message
...
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
--
Mike

find names of routine in modules in many workbooks
 

WOW - what a help - works like a champ.

Can't thank you enough.

Mike