Excel VBA Utilities

[Ken Loomis]

I do a lot of web design using Dreamweaver. Since a website may contain many
web pages, there is a neat feature that lets me check for unused (or,
unlinked) pages.

I was wondering if there weren't a set of programmer's utilities for Excel
VBA that would do something similar.

For example, if I declared a variable, but that variable was never used
anywhere, the utility would notify me of that.

Or, give me a list of all variables (including type, scope & values for
constants) and the macros they were declared or used in.

It's been a long time since I did much programming, but I remember having
these types of utilities and was just looking for suggestions.



Thanks,

Ken Loomis

 

[keepITcool]

you'll want: MZTools 3.0 for VBA

an excellent free utility from Carlos J. Quintero
can't do without it myself

http://www.mztools.com/download/mztoolsvba.zip

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Ken Loomis]

Thanks, keepITcool.

Those tools are exactly what I was looking for.