View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Molyneaux Mike Molyneaux is offline
external usenet poster
 
Posts: 17
Default 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