Description

Visual Basic/VBA Coding Tools for Your Entire Enterprise
Integrated directly into the Microsoft Visual Basic/Visual Basic for Applications (VBA) Integrated Development Environment, Total Visual CodeTools gives you a rich set of enterprise-enabled coding tools. Increase productivity and let your entire  development team share a consistent set of standards and rules across your VB, Access and Office applications.

Features

Code Cleanup
Code Cleanup is one of the most powerful features of Total Visual CodeTools. Code Cleanup standardizes the code in your project to your specifications. Add error handling to procedures that lack it, standardize code indentations, apply your variable naming convention, insert comment structures, sort procedures, and more. The result is code that is more readable, robust, and maintainable.

The Code Cleanup tool applies consistent formatting, adding error handling to procedures that lack it, and more. 
Learn more about Code Cleanup

Code Delivery
Code Delivery prepares your code for distribution. Add line numbers to every line so your error handler can pinpoint errors after your application ships. Drastically reduce the time and headaches spent reproducing bugs, or trying to decipher user bug reports. Code Delivery can also remove all debug code, rename variables to meaningless words, and compresses code (eliminate blank lines and comments) for faster execution and improved security in non-EXE environments such as Microsoft Office. 

Code Delivery provides the following code operations:

• Line Numbering adds line numbers to every line of code. With this, if your error handler uses the ERL function, it can detect the exact line where a crash occurs
• Variable Scrambling lets you rename all your variables, constants, user defined types, and enum to nonsense names that another user would have great difficulty deciphering. An option is available to not modify public variables
• Remove Comments removes all your comments. There is a way to not delete certain comments if they are tagged
• Remove Blank Lines removes all blank lines
• Remove Indentations makes your code flush left
• Remove Debug Statements removes this debugging code
• Remove Stop statements removes stop commands

Code Builders
Code Builders are available to help you create new code quicker and with flawless conformance to your standards. All builders use the shared standards you define--just point and click and new code is generated for many aspects of your application.

Total Visual CodeTools     (click images to enlarge)

Coding Tools
Total Visual CodeTools also includes a set of coding tools to handle the more mundane tasks of working with VB and VBA, such as:

• Close Code Windows: This tool makes it easy clean your development environment of code windows.
• Clear Immediate Window: This tool makes it simple to clear the content of the Immediate window.
• Block Commenter: This utility provides a better option to comment your code. 
• VBE Color Schemes: A tool which helps to visually organize the appearance of your Visual Basic Editor.

Enterprise Enabled Standards Management
Total Visual CodeTools allows you to define all aspects of your coding standards, including visual style, indentation, error handling, commenting, variable naming conventions, and more. Define your settings once, save them to a shared location, and your entire team can use your enterprise standards without even thinking about it.

Total Visual CodeTools tackles this problem by offering a powerful and flexible architecture for managing your standards.

• As a single developer, you can use Total Visual CodeTools to ensure that all your project conform to the development standards dictated by the project. With support for multiple standards templates, you can customize standards according to a specific client's needs, or a particular project's requirements.
• As a team or enterprise developer, Total Visual CodeTools standards allow you to develop projects without worrying about whether or not you are conforming to the defined project standard.
• As a development manager, you now have a tool to define development standards, and enforce them among entire project teams.

Code Cleanup

Additional information for the Code Cleanup tool is listed below.  Click here for an example showing how it works. 

Visual Style
Standardizing the visual appearance of the code is probably the single most important factor for code maintainability. Choosing this option tells Code Cleanup to do the following:

• Standardize Code Indentation to a specified width with automatic indentation for programming constructs such as IF..ELSE..ENDIF, DO..LOOP, WITH..END WITH, etc.
• Split multiple lines on one line separated by colons into separate lines
• Split single line If statements into separate lines with a closing End If.
• Split Dim statements for multiple variables on one line into separate lines.
• Standardize number of blank lines between procedures
• Standardize maximum consecutive blank lines.

Procedure Sorting 

Procedures can be inserted in any order in VB/VBA. This may be good, but it can also create a mess. Code Cleanup makes it easy to sort the procedures in your modules including property statements in class modules.

Module Comments
Add a standard module header to the top of each module such as a project name, creation dates, copyright notices, and ownership rights. A complete list of all procedure names and procedure definitions can also be added.

Procedure Comments
Add comment headers to each procedure. Although the program cannot determine what the code is actually doing and write the comments for you, it can take much of the drudgery out of the process of creating consistent comment headers for each procedure.

Property Comments
Insert the specified property comment template into all the property procedures.

Error Handling
Error handling is one of the key attributes of robust applications. This feature inserts error handling code into your procedures that lack error handling, and allows you to specify separate error handling routines for regular modules vs. class modules. Error handling can also be added in a way to be automatically updated in the future.

Variable Naming Conventions
Rename your existing variables to conform to naming conventions based on the variable type (Integer, String, etc.). Every variable is given a prefix or suffix identifying its type with additional options for global and module level variables.

Option Explicit
Insert "Option Explicit" into the declarations section of every module that lacks it. One of the cardinal rules of writing reliable and maintainable code is to explicitly declare all of your variables. By adding "Option Explicit" to your module, you are telling Access to require variable declaration.

Remove Line Numbers
Removes the line numbers in your code. This is useful if line numbers were added to your code (say with the Code Delivery feature), and you now want to remove them.

Download Demos

Follow the link below to see how the Total Visual CodeTools product can help you. The trial version will only operate for 14 days; after that time, the program will expire. The trial version only allows Code Cleanup and Code Delivery to be run on one module at a time.

Total Visual CodeTools for Access 2003/2002/2000 and VB 6.0
 

Pricing
Total Visual CodeTools for Access and VB - Single License		$295
Total Visual CodeTools for Access and VB - 5 User License		$895