Solved

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

Posted on 2013-01-28
11
190 Views
Last Modified: 2013-01-28
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
Comment
Question by:Dov_B
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 200 total points
ID: 38826592
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
 

Author Comment

by:Dov_B
ID: 38826850
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
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 38826860
Can you post a link to the utility, so that we can try to work out/guess what it does?
0
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 

Author Comment

by:Dov_B
ID: 38826869
0
 

Author Comment

by:Dov_B
ID: 38826871
0
 
LVL 21

Assisted Solution

by:EricFletcher
EricFletcher earned 200 total points
ID: 38827015
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
 
LVL 59

Assisted Solution

by:Chris Bottomley
Chris Bottomley earned 100 total points
ID: 38827285
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
 

Author Comment

by:Dov_B
ID: 38827298
Dear Eric how do I go about building a table of contents its a new concept for me
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 200 total points
ID: 38827327
There's a button at the left hand end of the References tab on the Ribbon
0
 
LVL 21

Accepted Solution

by:
EricFletcher earned 200 total points
ID: 38827428
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
 

Author Closing Comment

by:Dov_B
ID: 38827844
Thanks as always you guys are angels! May you be blessed with everything Good!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question