VBA Code Profiler

<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> <B>VBA Code Profiler</B></div> <div> <A HREF="vbprt.htm" TARGET="_top" TITLE="VB/VBA Code Printer"><U>VB/VBA Code Printer</U></A></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=VBACP" 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>VBA Code Profiler</B></div> <div> <I><B>Overview</B></I></div> <div> The VBA Code Profiler System (VBACP) provides a system to profile Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> VBA based applications. This will allow analysis of your code for performance and path tracking throughout your VBA project. The VBACP system  will operate on any Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> VBA based application from Office 97, 2000, 2002/XP,  2003, and 2007. The profiler itself is required to be installed into your code and then you are required to instrument the code requiring profiling.</div> <div> Systems currently supported are Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> 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>. If you require additional modules, please contact us. </div> <div> The diagram below, illustrates the resultant code after the code has been instrumented and the profile initialisation and report commands added.</div> <div> <IMG SRC="85609330.jpg" border=0 width="521" height="307" 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> <bR> <div> <I>System Pre-requisites</I></div> <div> The VBA Code Profiler (VBACP) system requires any of the Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> VBA systems from Microsoft<FONT SIZE="1" COLOR="#000000" FACE="Arial" >®</FONT> Office 97, 2000, 2002/XP, 2003, and 2007 suites of software to be installed and required to be profiled.</div> <bR> <div> <I>Instrumenting your Code</I></div> <div> Instrumenting, and finally cleaning your code, is as simple as inserting the profiler form into your code and running it.</div> <div>  <IMG SRC="87cff300.jpg" border=0 width="511" height="304" 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> There is also a batch utility to allow you to instrument/clean multiple Word and Excel projects in a single pass. Below is a sample screenshot of the batch installer:</div> <div> <IMG SRC="88232bb0.gif" border=0 width="306" height="187" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"> <FONT SIZE="2" COLOR="#000000" FACE="Arial" ></FONT></div> <bR> <div> <I>The Profile Report</I></div> <div> The output is in the form of a text based report to allow importing into Excel and other tools for graphing purposes. The report produced by the VBACP system is illustrated below, detailing the results:</div> <div> <IMG SRC="8880f220.jpg" border=0 width="527" height="290" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"> <FONT SIZE="2" COLOR="#000000" FACE="Arial" > <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> <a href="javascript:displayWindow('id197.htm',425,650)">Zoom</a>  </FONT></div> <bR> <div> <IMG SRC="7c726050.gif" border=0 width="550" height="5" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <div> You may download the full set of VBA Code Profiler System documents directly from this link <A HREF="http://www.bandwood.com/Downloads/VBA_Code_Profiler.zip" TARGET="_top" TITLE="http://www.bandwood.com/Downloads/VBA_Co"><U>VBA_Code_Profiler.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="7c726050.gif" border=0 width="550" height="5" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <div> © Copyright 1999-2010 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-2010 by Bandwood Pty Ltd. All rights reserved.</font></td> <td align="right"><font color="silver" face="Tahoma" size="1">Site last updated on 19-Feb-10.</font></td> </tr> </table>  </div> </td> </tr></table></body>