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

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" wrote:

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

Thanks, keepITcool.

Those tools are exactly what I was looking for.

"keepITcool" wrote in message
...
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" wrote:

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