Increase Your Productivity and Deliverables with Coding Tools for Microsoft^® Office^®, VBA^®, and Visual Basic^® (VB6)

Professional Coding Utilities

Total Visual CodeTools 2007 supports all VB/VBA hosts, including Visual Basic 6.0 (VB6), Office 2007, Office 2003, Office XP/2002, and Office 2000 (include Microsoft Access, Excel, Word, PowerPoint, Outlook, etc.). Loaded directly into the Integrated Development Environment (IDE), Total Visual CodeTools gives you a rich set of coding tools to increase your productivity and make your entire development team more effective.

Total Visual CodeTools makes it easy to:

• Write solid code
• Reduce the drudgery of common tasks
• Clean up inherited code and standardize existing code
• Rename variables to your naming convention
• Create maintainable code
• Find unused variables, constants, classes, user defined types, etc.
• Add sophisticated error handling and line numbering to pinpoint crashes
• Deliver code that is more difficult to decipher

Code Cleanup: Format and Standardize VBA/VB6 Code

Address issues that come with inherited code by applying consistent line formatting and indentations, custom error handling to procedures that lack it, renaming variables to your naming convention (e.g. all integers start with int, strings with str, etc.), and much more.

Sample VBA/VB6 Code Formatting and Standardization

Code Delivery: Add Line Numbers and Obfuscate VBA/VB6 Code

Before distribution, easily add line numbers to all of your code so you can take advantage of VB6/VBA’s ability to pinpoint the exact line where an error occurs. You can also obfuscate your code for situations where you need to distribute your source code, but are concerned about its misuse.

Sample VBA/VB6 Code Line Numbering and Obfuscation

Code Builders: Simplify Coding Chores

Simplify the development process and ensure that new code follows your organization's standards for naming, commenting, error handling, and more:

• New Procedure Builder to create procedures with your custom commenting and error handling structure while automatically referencing the module and procedure names
• Recordset Builder to create DAO and/or ADO code to browse, add or edit a record from tables and queries
• Long Text Builder to convert SQL strings from a query to code while handling issues such as quotes and smart word-wrapping based on line length and SQL words (like WHERE, JOIN, etc.).
• Message Box Builder to visually use the MsgBox command and its results
• Select Case Builder to easily create SELECT CASE statements
• Copy Control Builder to easily copy all the events of one control to another control in the same form/object or another one
• New Property Builder to easily create Let, Get, and Set statements with your custom commenting and error handling structure, along with the declaration level property variable
• Format Builder to easily use the Format command to manage strings, numbers, currency and dates
• DateDiff Builder to easily use the DateDiff builder to compare two dates

Take the Builders Tour for more details on each builder.

Additional Coding Tools

• Unused Variable Analysis analyzes your entire project to find unused variables, constants, classes, user defined types, and elements
• Macro Recorder to record and reply keystrokes to simplify the repetition of a complex set of tasks
• Code Commenter that comments and uncomment blocks of code with advanced features
• VBE Color Scheme manager to easily see and set colors for your editor
• Close Code Windows to close all open windows (for VB6 it handle objects and code separately)
• Clear Immediate Window

Total Visual CodeTools Improves Quality and Reduces Costs

We're so confident in this product's power, we guarantee that it will save time and money in the first week of use. If not, return it for a prompt and courteous refund within 30 days.

Download the trial version to see how it can work for you.

Total Visual CodeTools Pricing for Visual Basic (VB6) and VBA such as Microsoft Office/Access/Excel/Word
Licenses	Price	2007, 2003, 2002, 2000, VB6	97
Single	$299
5 Seat	$899
Upgrade Single	$199
Upgrade 5 Seat	$599
Premium Support Subscription
Single License	$299
5 Seat License	$999
More Information
Also Available as part of:
Total Access Ultimate Suite Total Access Developer Suite Total Visual Developer Suite Total VB Developer Suite
Runtime/Redistributable Version
Not Applicable
Licensing Information
Total Visual CodeTools is licensed on a per developer basis. Each developer who uses the program must have a license.