Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find names of routine in modules in many workbooks
WOW - what a help - works like a champ.
Can't thank you enough. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find matching tab names between different workbooks | Excel Programming | |||
Find names of all open workbooks | Excel Programming | |||
Importing Modules From Other Workbooks | Excel Programming | |||
separate modules for each sub routine? | Excel Programming | |||
Sub Routine Names As Variables | Excel Programming |