Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

is there a utility that makes it easier to see all the macros in a vba module like an explorer or tree

years a go I found this utility for excel vba writing that showed all the macros in a module in a tree and made it real easy to collect snippets of code but I can't find it. Is there such a program for ms word 201
0
Dov_B
Asked:
Dov_B
  • 5
  • 3
  • 2
  • +1
5 Solutions
 
GrahamSkanRetiredCommented:
Not all code can be displayed as a simple tree. Many procedures can be called from more than one place, so there would be duplication. Also code can be recursive.

Generally flow charts are used to portray the links between procedures.

To write your own, you would need to use the code in the Microsoft Visual Basic for Applications Extensibility library.

Otherwise try Googling for 'flow chart from VBA code'.
0
 
Dov_BAuthor Commented:
Thanks Grahamskan you have come to my rescue so many times!
But there is a program that give explorer like tree like lists of macros in a module which I finaly found but with one small problem they want $100 which I cannot afford
I don't need a flow chart of subroutine and function that call each other rather a simple list of vba macros that reside in a particular module
where can I find either a free or very cheap tool that does that or perhaps code that will list the names of all the macros in a module
0
 
GrahamSkanRetiredCommented:
Can you post a link to the utility, so that we can try to work out/guess what it does?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Dov_BAuthor Commented:
0
 
Dov_BAuthor Commented:
0
 
Eric FletcherCommented:
If you want a general case solution this may not be applicable, but to get a formatted list of all Subs and Functions, you could just open the module and copy it. Then open a new Word document and paste.

You can make it more useful by using Find and Replace to tag the "Sub" and "Function" lines as heading levels. That would make the names stand out better (bold, extra space, etc.), but also it would allow you to build a table of contents to show a summary of the contents.

I've done this over the years to build up a library of code snippets going back to WordBasic days.
0
 
Chris BottomleyCommented:
Whilst it does not address the calls, see http://msdn.microsoft.com/en-us/library/office/dd890502(v=office.11).aspx for some code (excel but adapts to word easily enough) to list all the subs.

Chris
0
 
Dov_BAuthor Commented:
Dear Eric how do I go about building a table of contents its a new concept for me
0
 
GrahamSkanRetiredCommented:
There's a button at the left hand end of the References tab on the Ribbon
0
 
Eric FletcherCommented:
After you paste all of the code in from a module, open the Find and Replace dialog (Ctrl-H) and click the "More >>>" button.

In the Find what box, type "Sub " (that's S u b space without the quotes). In the Replace with box, type the same thing, but then click the Format button and choose Style. Within the style list, choose "Heading 1". This tells Word to look for any "Sub " and replace it with the same thing but also to add the Heading 1 style to it. Click Replace All.

Now all your Subs will have the Heading 1 style. You can repeat for Functions, and if you choose, make them a different style (say Heading 2).

To create the table of contents, move to the start of the new document (Ctrl-Home) and choose the top option of the References ribbon's "Table of Contents" button (far left). This will insert a default ToC showing you the name of each Sub with the page number. If you have used Heading 2 for the Functions, they will be listed as well. You can modify the ToC by editing the TOC field code, but this is probably sufficient for most purposes.
0
 
Dov_BAuthor Commented:
Thanks as always you guys are angels! May you be blessed with everything Good!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now