• Home
• Products
  Complete Product List New Products Free Products Analysis Products Charting Products Data Products Macro Books Specialty Products Time Saving Products Workbooks/Templates Products by Others iPhone Applications
• Product Collections
  Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
• Save $'s
  Volume discounts Past customers discounts Buy a collection! Buy the Productivity Suite!
• Download
  Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
• Support
  Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
• Company
  About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

There are several key steps one can do to document macro code and to make it more understandable, both when you are first creating it and when you look at it again months later:

• Add comment lines. Comments lines begin with a single quote:  'this is a comment
• Change the background color of comment lines to light blue.  In the VB Editor, select Tools, Options, Editor Format and change there
• Add documentation at key steps in the module and in a module at the front.  Typically we name the module "AAA-Documentation"
• Use very long variable names
• Use very long macro names
• Use many small routines called by one routine versus one very long macro.  Pass variables back and forth
• Use the Code Documentor developed by Rob Bovey to analyze and document your project

Memory usage: Code Documentor is a VBA add-in.  Such add-ins use less memory than COM add-ins and have 5-10 open at a time typically has little to no effect on Excel memory.  Use of the Add-In Information Lister to manage add-ins, removing those not needed and then re-installing when needed is best.

The Code Documentor provides a list of the sheets, userforms, and modules in your project, how many procedures (macros) in each, and how many lines of code.  It does not list the individual macro names or what variables are being used when calling them.  Nor does it list any of the comments found in the macros.  The key benefit is knowing if your lines of code in a module is exceeding 600 lines.  Code that is more than 600 lines has sometimes been know to become corrupt.  It is best to keep modules below 600 lines, and always below 1000 lines.

To use the Code Documentor after installing, open your workbook or add-in containing your code.  If the code is password protected, access the project so that the code is viewable.  Then, do the following:

• For excel 200-2003, select Tools, Macro, Security.  the following dialog appears:

• If you are using Excel 2007, select Office Button,  Excel Options, Trust Center, Trust Center Settings, Macros.  The following dialog appears:

To use the Code Documentor after installing :

• Make a backup copy of your project.  This insures you can recover back to it in case use the Code Documentor causes a problem
• From a Microsoft Excel worksheet, if Excel 2003-2010, select Tools, Document Project. If Excel 2007, click on the add-ins ribbon and click on one of the "Document Project" button (there is a bug in the Code Documentor that shows two buttons)
• Select your project and click OK.  A documentation worksheet is created.

View Cart   Quantity Discount 2 10% 3 20% 4 30% 5-9 40% 10 or more 50%

Order online from our
secure service
Get delivery in minutes!

Order Risk Free
Money back guarantee
if not satisfied

Buy individually
or as part of the Productivity Suite
and save