VB/VBA Code Printer

<body topmargin=0 leftmargin=0 marginheight=0 marginwidth=0> <table cellpadding=0 cellspacing=0 border=0><tr> <td valign="top" rowspan="3" width=180 BGCOLOR="#003333" TEXT="#F7F7FF" background="0f6d4c00dduajq.png"> <div> <TABLE BORDER="0" CELLPADDING="2" CELLSPACING="0" WIDTH="95" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="BOX" RULES="ALL" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 46 WIDTH="91"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="46" ALIGN="bottom" WIDTH="91" HSPACE="0" VSPACE="0"></tD> </tR> </TABLE></div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <FORM action="http://www.bandwood.com/cgi-bin/ksearch/ksearch.cgi" method="get" name="search" target="TRLX_Middle"> <INPUT type="text" size=18 name="terms" value="" onFocus="select(this);"><BR> <BUTTON TYPE="submit" style="background: none; border: none; width: 8em"><font face="Tahoma" size="2" color="#FFFF00"><U>Search this Site</U></font></BUTTON> <INPUT type=hidden name="sort" value="Matches"> <INPUT type=hidden name="display" value="10"> <INPUT type=hidden name="b" value="1"> <INPUT type=hidden name="t" value="1"> <INPUT type=hidden name="d" value="1"> <INPUT type=hidden name="all" value="0"> </FORM></div> <div> <A HREF="cms_exec_summary.htm" TARGET="_top" TITLE="Change Management Requirement Tracing S"><U>Change Management & Requirement Tracing System</U></A></div> <div> <A HREF="fms.htm" TARGET="_top" TITLE="Fax Management System"><U>Fax Management System</U></A></div> <div> <A HREF="gbs.htm" TARGET="_top" TITLE="Gantt Chart Builder System"><U>Gantt Chart Builder System</U></A></div> <div> <A HREF="vbacp.htm" TARGET="_top" TITLE="VBA Code Profiler"><U>VBA Code Profiler</U></A></div> <div> <B>VB/VBA Code Printer</B></div> <div> <A HREF="dcr.htm" TARGET="_top" TITLE="Database Content Reporter"><U>Database Content Reporter</U></A></div> <div> back to <A HREF="products.htm" TARGET="_top" TITLE="PRODUCTS"><U>PRODUCTS</U></A></div> <bR> <div>  <a href="http://www.bandwood.com/_Store/commerce.cgi?product=PRT" target="TRLX_Middle"><img src="http://www.bandwood.com/_Store/html/images/buynow1.jpg" width=79 height=21 border=0 alt="Go to Store"></a>  </div> </td> <td valign="top" colspan=2 height=25 BGCOLOR="#003333" TEXT="#F7F7FF"> <div> <A HREF="index.htm" TARGET="_top" TITLE="Bandwood Pty Ltd"><U>HOME</U></A>  |  <A HREF="services.htm" TARGET="_top" TITLE="SERVICES"><U>SERVICES</U></A>   |   <A HREF="products.htm" TARGET="_top" TITLE="PRODUCTS"><U>PRODUCTS</U></A>   |   <A HREF="purchase.htm" TARGET="_top" TITLE="PURCHASE"><U>PURCHASE</U></A>   |   <A HREF="downloads.htm" TARGET="_top" TITLE="DOWNLOAD"><U>DOWNLOAD</U></A>   |   <A HREF="support.htm" TARGET="_top" TITLE="SUPPORT"><U>SUPPORT</U></A>   |   <A HREF="search.htm" TARGET="_top" TITLE="SEARCH"><U>SEARCH</U></A>   |   <A HREF="site_map.htm" TARGET="_top" TITLE="SITE MAP"><U>SITE MAP</U></A>   |   <A HREF="contacts.htm" TARGET="_top" TITLE="CONTACT US"><U>CONTACT US</U></A></div> <div> </div> </td> </tr><tr> <td valign="top" height=435 colspan=2 BGCOLOR="#FFFBF0" TEXT="#080000"> <div> <B>VB/VBA Code Printer</B></div> <div> <I><B>Overview</B></I></div> <div> The Visual Basic (VB) and Visual Basic for Applications (VBA) Code Printer (VBPRT) allows you to print a formatted copy of your code in a single program.</div> <bR> <div> Also available in the printout are certain statistics about your code, such as lines of code, number of comment lines, number of functions, subroutines etc. Also, some project parameters are also printed with the report.</div> <div> The VB Code Printer will operate on any project developed under Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Visual Basic 5 or Visual Basic 6. It will also operate on any Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Word<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT>, Access<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT>, or Excel<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Visual Basic for Applications (VBA) code from Office versions 97, 2000, 2002/XP, 2003 or 2007. <FONT SIZE="2" COLOR="#FF3333" FACE="Arial" >Please note, the Acess</FONT><FONT SIZE="1" COLOR="#FF3333" FACE="Arial" >®</FONT><FONT SIZE="2" COLOR="#FF3333" FACE="Arial" > version will not operate under Office 97.</FONT></div> <div> An additional feature of this tool is that you can take a page and copy it into your computer's clipboard so that you can paste it into any other program of your choosing.</div> <div> The diagram below, illustrates a sample of the formatted output from this program.</div> <div> <IMG SRC="acfdcc10.jpg" border=0 width="476" height="449" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"> <FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id244.htm',520,690)">Zoom</a>  </FONT></div> <div> The figure below is a sample of the code statistics page.</div> <div> <IMG SRC="ad2db290.jpg" border=0 width="475" height="297" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"><FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id245.htm',520,690)">Zoom</a>  </FONT></div> <bR> <div> <I>System Pre-requisites</I></div> <div> The VB Code Printer (VBPRT) system requires no additional software installed, except when printing any of the Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> VBA systems then Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Office will be needed.</div> <div> If printing a Visual Basic (VB) project, Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Visual Basic/Visual Studio is not required to be installed.</div> <bR> <div> <I>Main Window's Tab Structure</I></div> <div> The application has two tabs, one for detailing the contents of a specific project and allowing the user to select the appropriate components. The other tab is used to configure the code printer system. These two tabs are detailed below.</div> <div> <B>Details Tab</B></div> <div>  <IMG SRC="ad8d6040.png" border=0 width="470" height="260" ALT="Microsoft PowerPoint Presentation" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"> <FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id246.htm',520,690)">Zoom</a>  </FONT></div> <div> <B>Configuration Tab</B></div> <bR> <div> <IMG SRC="adcd84f0.png" border=0 width="472" height="335" ALT="Microsoft PowerPoint Presentation" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"> <FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id247.htm',520,690)">Zoom</a>  </FONT></div> <bR> <div> <IMG SRC="ab826050.gif" border=0 width="550" height="5" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <div> You may <FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id241.htm',575,500)">Send an E-mail Request</a>  </FONT>for a copy of the VB/VBA Code Printer System documents to be sent back to you via e-mail or you may download a copy of this page directly from this link <A HREF="http://www.bandwood.com/Downloads/VB-VBA_Code_ Printer.zip" TARGET="_top" TITLE="http://www.bandwood.com/Downloads/VB-VBA"><U>VB-VBA_Code_Printer.zip</U></A>.</div> <bR> <div> Adobe Acrobat (PDF) files require Adobe Acrobat Reader. Acrobat Reader can be obtained from Adobe. <A HREF="http://www.adobe.com/products/acrobat/readstep.html" TARGET="_top" TITLE="http://www.adobe.com/products/acrobat/re"><U><IMG SRC="082581f0.png" border=0 width="88" height="31" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></U></A></div> <div> <IMG SRC="ab826050.gif" border=0 width="550" height="5" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <div> © Copyright 1999-2009 by Bandwood Pty Ltd.  All rights reserved.  This document contains information proprietary to Bandwood Pty Ltd.  No part of this document may be reproduced in any form by any means without permission in writing from Bandwood Pty Ltd ( <SCRIPT LANGUAGE="JavaScript">  </SCRIPT>  ).</div> <div> Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Office 97/2000/XP/2003/2007, Excel<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®, </FONT>Word<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT>, and Access<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> are trademarks of Microsoft Corporation, USA<FONT SIZE="2" COLOR="#000000" FACE="Arial" > <HEAD> <META NAME="abstract" CONTENT="Bandwood Pty Limited is an Australian owned company that specialises in management consulting services and custom software/systems development. Development specialilities include Visual Basic applications, Microsoft Excel (Spreadsheet) applications, Word templates and document skeletons, and Access applications. We also have a number of software packages and project management methodologies that have been developed and are used constantly within our own management services. The products include Change Management software, comprising Project Management tracking and control tools, including database control, system's defect tracking, system's design control, and project scope control, Project Risk Management System, Project development methodologies, Requirement tracing throughout the SDLC. Fax Management software to control ASCII data streams into formatted faxable document."> <META HTTP-EQUIV="Content-Language" CONTENT="EN"> <META NAME="revisit-after" CONTENT="5 days"> <META NAME="copyright" CONTENT="Bandwood Pty Limited"> <META NAME="robots" CONTENT="FOLLOW,INDEX"> </HEAD>  </FONT></div> </td> </tr><tr> <td valign="top" colspan=2 height=20 BGCOLOR="#003333" TEXT="#F7F7FF"> <div>  <table border="0" style="width: 100%; margin: 0em 0em 0em -0.5em" cellspacing="0" cellpadding="0"> <tr> <td align="left"><font color="silver" face="Tahoma" size="1">© Copyright 1999-2009 by Bandwood Pty Ltd. All rights reserved.</font></td> <td align="right"><font color="silver" face="Tahoma" size="1">Site last updated on 22-May-09.</font></td> </tr> </table>  </div> </td> </tr></table></body>