VBA tools for code analysis?

W

willcarter

Hi

I've just taken over a dormant VBA project (MS Word) and am working my
way through the code, trying to work out what it's doing (it wasn't
well commented, unfortunately). I'm coming across a few problems, for
instance procedures that are not actually used i.e. not called from
anywhere. I guess they were once used, but were not deleted when the
developer had a new idea or new requirement.

I was just wondering if there was any tools or utilities out there that
might help me do this analysis. I've looked on the web and found that
there's a whole bunch of heavy duty (and expensive) tools that go way
further than I need. I'm looking for something pretty simple e.g. that
will list the dead procedures and perhaps point out some inefficiencies
in the code. I assumed there would be a load of cheap tools out there
but I can't find any.

Do they exist, and could someone point me in the right direction?

Kind regards

Will (UK)
 
J

Jonathan West

Hi Will

I would recommend the following, completely free. It does just about all you
have mentioned.

MZ Tools 3.0 for VB6 & VBA
http://www.mztools.com/index.htm

In addition, I would recommend the following, also free, which does a
somewhat different but also extremely useful job.

Smart Indenter
http://www.oaltd.co.uk/Indenter/Default.htm


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
W

willcarter

Jonathan said:
Hi Will

I would recommend the following, completely free. It does just about all you
have mentioned.

MZ Tools 3.0 for VB6 & VBA
http://www.mztools.com/index.htm

In addition, I would recommend the following, also free, which does a
somewhat different but also extremely useful job.

Smart Indenter
http://www.oaltd.co.uk/Indenter/Default.htm

Jonathan -- that's fantastic. Thank you so much. I've had a brief look
at them, and between them, seem to do pretty much what I want.

Wel done mate, you've made my day!!!!

THREE CHEERS FOR JONATHAN!!

Hip hip hooray!

Regards

Will
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top