Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Unreferenced Subs and Functions
I have a fairly large add-in that has had a lot of people's hands in it. I
was wondering if anybody knew of a utility that would analyze the add-in to try and find unreferenced Subs and Functions? I say "try" because I understand that the kind of static analysis such a utility would perform would necessarily be imperfect. Still I would love to have the recommendations from such a utility to guide my cleanup effort. TIA, josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Unreferenced Subs and Functions
Hi there,
Check out M-Z Tools. It will find unused variables and such and it will give you listings of unused procedures. From the VBE, Tools | MZ Tools | Other Utilities | Review Source Code. HTH -- Regards, Zack Barresse, aka firefytr To email, remove NOSPAM "Josh Sale" <jsale@tril dot cod wrote in message ... I have a fairly large add-in that has had a lot of people's hands in it. I was wondering if anybody knew of a utility that would analyze the add-in to try and find unreferenced Subs and Functions? I say "try" because I understand that the kind of static analysis such a utility would perform would necessarily be imperfect. Still I would love to have the recommendations from such a utility to guide my cleanup effort. TIA, josh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Unreferenced Subs and Functions
Also, beware when it says a procedure is unused. If the procedure is called
via string syntax, i.e. Application.Run method, then it will not pick it up. -- Regards, Zack Barresse, aka firefytr To email, remove NOSPAM "Josh Sale" <jsale@tril dot cod wrote in message ... I have a fairly large add-in that has had a lot of people's hands in it. I was wondering if anybody knew of a utility that would analyze the add-in to try and find unreferenced Subs and Functions? I say "try" because I understand that the kind of static analysis such a utility would perform would necessarily be imperfect. Still I would love to have the recommendations from such a utility to guide my cleanup effort. TIA, josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subs or functions with user defined types | Excel Programming | |||
Common Functions and Subs | Excel Discussion (Misc queries) | |||
Where to Place Public Subs and Functions | Excel Programming | |||
Called subs versus functions | Excel Programming | |||
Calling VBA add-in functions/subs from another Excel file. | Excel Programming |