Any one know of a programmer's companion to help keep track of a VBA
project?

For example, I use Dreamweaver for web design. It allows me to analyze a web
site for missing links and unused files.

Something like that for Excel VBA would be nice.

Thanks for your suggestions.

Ken

Ken,

Take a look at Rob Bovey's Code Documenter
http://www.appspro.com/Utilities/Documentor.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken Loomis" wrote in message
...
Any one know of a programmer's companion to help keep track of a VBA
project?

For example, I use Dreamweaver for web design. It allows me to analyze a
web
site for missing links and unused files.

Something like that for Excel VBA would be nice.

Thanks for your suggestions.

Ken

There is nothing like this that I know of. The best solution that I have
found is to comment your code include dsecriptions of all of your variables
as soon as you get things working. This usually helps you find moat of the
garbage that accumulates while you were writting. It is tough to add
meaningful comments to garbage.

I am with you though. The C/C++ compiler points out all of that garbage for
you.
--
HTH...

Jim Thomlinson


"Ken Loomis" wrote:

Any one know of a programmer's companion to help keep track of a VBA
project?

For example, I use Dreamweaver for web design. It allows me to analyze a web
site for missing links and unused files.

Something like that for Excel VBA would be nice.

Thanks for your suggestions.

Ken

Roedd <<Ken Loomis wedi ysgrifennu:

Any one know of a programmer's companion to help keep track of a VBA
project?

This includes great tools for analyzing projects for unused variables,
uncalled procedures etc. plus documentation tools and much more. It's free,
too.

http://www.mztools.com/v3/download.htm

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

I agree 100% with Robert - mztools is a great free gadget (and no, I do not
have any association with mz tools) that I have been using constantly for the
last couple of years.

--
www.alignment-systems.com


"Robert Bruce" wrote:

Roedd <<Ken Loomis wedi ysgrifennu:

Any one know of a programmer's companion to help keep track of a VBA
project?

This includes great tools for analyzing projects for unused variables,
uncalled procedures etc. plus documentation tools and much more. It's free,
too.

http://www.mztools.com/v3/download.htm

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.