LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find matching tab names between different workbooks Freddy Excel Programming 12 March 13th 07 05:44 PM
Find names of all open workbooks Graham Whitehead Excel Programming 2 November 15th 06 02:39 PM
Importing Modules From Other Workbooks Jim Jackson Excel Programming 2 July 14th 06 07:55 PM
separate modules for each sub routine? smokiibear Excel Programming 7 January 26th 05 03:36 PM
Sub Routine Names As Variables [email protected] Excel Programming 2 January 15th 04 09:54 PM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"