Excel Macro "relationship" grapher ??

S

Sean O'Neill

I have a rather old Excel VBA application I wrote so years ago that I
would like to get working again. (Oh why did it stop working ?) It
stopped working because I'm a dork, didn't keep a copy of the final
working version, made modifications that I never finished, and now I
could really it right now for something I'm looking at.

So I'm hoping to find something I can use to look at my code and show me a
sorta graphical relationship diagram of the macros and what references
what. Even a text version of the reference relationship would work fine.

Is there any such beast that does this for Excel VBA applications ?
 
D

David McRitchie

Hi Sean,
You can get a list of Function and Sub and identify duplicate
names, and it is reading code and tells how many lines each
subroutine/function has.
Subroutine and Function Table for Open Workbooks (#ListFunctionsAndSubs)
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#listfunctionsandsubs

Something more along the lines of what you asked might be found in
Rob Bovey's "Code Documentor" at
http://www.appspro.com/Utilities/Utilities.htm

Pehaps not useful at the moment for what you are looking for, but
another good place to look would be Stephen Bullen's MVP page
http://www.bmsltd.ie/mvp/MVPTitl.htm
which often has addins for some more difficult and intensive work that
you need from time to time. Stephen's own work can be seen from
his home page. http://www.bmsltd.ie/Excel/Default.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
S

Sean O'Neill

Hi Sean,
You can get a list of Function and Sub and identify duplicate
names, and it is reading code and tells how many lines each
subroutine/function has.
Click to expand...
<SNIP>

Thanks Dave !!! Much appreciated.
 
Top