VBAcodePrint

This is a tool that helps get program listing of VBA code in a color coded and formatted fashion.

VBAcodePrint is a Visual Basic for Applications (VBA) Add-in. This tool enables you to get the source code printed in well formatted and color coded fashion that improves readability. As most developers know good readability is a major tool for debugging and documentation of programs. This add-in works with VBA 6 and VBA 7. You will be, thus, get the source code printed of your applications across the entire Microsoft Office XP, 2000-2013, 32-BIT and 64-BIT suite of applications, as well as other VBA Enabled applications such as CorelDraw, Visio and AutoCAD. This tool makes the source code very presentable. Source code of VBA 6 and VBA 7 can be presented to clients, reviewer and others in a very professional manner. Code walk-through became easier with the listing with line numbers, and syntax highlighted sources. You would be able to us the listings in presentations and handouts too.

Portrait as well as landscape page layouts are supported. Several page sizes can be used and is user selectable. To further doll up your code listing, you would be able to customize the listings with page headers and footers, and they can include project name, component name, project version, printed date, printed time and page numbers. Page numbers as well as their margins can be customized. Connecting lines that help printing of paired language constructs with connecting lines for better readability and checking. Indentation can be used effectively. You can have line numbers that restart at the beginning of a procedure or a page. Dividing lines could be used such that separation of procedures, functions, properties, etc. Several other effective features are available.

This add-in enables you to print Microsoft VBA source code in color of your applications across the entire Microsoft Office XP, 2007-2013 suite of applications: Word, Excel, Outlook, Access, PowerPoint, and FrontPage and any other VBA enabled software.
You can create and save your own output styles by customizing the fonts and colors settings for keywords, strings, constants, procedure headers, line numbers, page headers/footers. You can customize the page margins, line spacing, print quality, paper orientation, scaling, and much more.
You can select a set of procedures, components or projects for printing and the selection can be saved and restored for repeated prints of the same set of items.
You can also to print the output in multi-columns, customize the procedure separator to be a blank line, a line draw or a new page, and print each source code line with a line number that can be reset at top of a page, procedure, or continues for ease of code inspections.
You can preview the output before printing in many different formats and select pages to be printed.
The printed output can be exported to RTF and PDF format to enable it to be incorporated into a word processors.