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