Any way to find unused code?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Hillerson - 07 Mar 2005 06:03 GMT

Is there a program out there that I can run on a VBA project to find
functions that are defined by not used?

It's a big project that has evolved over the years, and I know there's
code that's no longer being called that's taking up space, so I'd lke
to find a tool that will help me clean up the code.

Any pointers appreciated.

thanks,
gary

Reply to this Message

Vince - 07 Mar 2005 06:59 GMT

Haven't used it first hand but everybody seems to recommend
http://www.mztools.com/

> Is there a program out there that I can run on a VBA project to find
> functions that are defined by not used?
[quoted text clipped - 7 lines]
> thanks,
> gary

Reply to this Message

Gary Hillerson - 08 Mar 2005 03:40 GMT

Thanks. Nice program. It doesn't find dead public functions, but does
a great job of finding unused private functions and variable and
params.

MZ-Tools also does a lot of wonderful things to improve the
development environment. Great stuff.

G

>Haven't used it first hand but everybody seems to recommend
>http://www.mztools.com/
[quoted text clipped - 10 lines]
>> thanks,
>> gary

Reply to this Message