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
187 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
Comment Utility
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
Comment Utility
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
Comment Utility
Can you post a link to the utility, so that we can try to work out/guess what it does?
0
 

Author Comment

by:Dov_B
Comment Utility
0
 

Author Comment

by:Dov_B
Comment Utility
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 21

Assisted Solution

by:EricFletcher
EricFletcher earned 200 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks as always you guys are angels! May you be blessed with everything Good!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now