Increase Your Productivity and Deliverables with Coding Tools for
Microsoft
Office, Visual Basic for
Applications (VBA),
and Visual Basic
(VB6)
NOW AVAILABLE FOR MICROSOFT OFFICE, ACCESS, EXCEL 2010
New Features:
|
- Supports Office/Access 2010 (32-bit version)
- VBA code parser supports 32 and 64 bit versions
- Code Cleanup and Delivery are faster with Apply Changes
option
- Copy Control Builder supports multiple controls
- Long Text/SQL Builder
supports query retrieval, converts tabs and spaces
- Select Case Builder supports text blocks and numeric
ranges
-
Recordset Builder
defaults to current database and simplifies selections
- Message Box Builder enhanced
- 3
Locations for Total Visual CodeTools on your menus
- Screens are resizable
- Redesigned storage of Standards and improved international support
- New help file and user manual
- all the new features...
|
Why Total Visual CodeTools Exists
We at FMS developed Total Visual CodeTools to address the challenges
we experienced in our own efforts to create great VB6 and VBA
applications. From writing new code, to taking over someone else's
work (or work we wrote years ago that looks like someone else wrote
it), Total Visual CodeTools automates many of the steps to make you
more productive.
Leveraging our technology to parse VBA/VB6 code, Total
Visual CodeTools not only creates new code but updates existing
code in powerful ways. It lets you apply Best Practices to your
projects and standardize existing solutions.
The result is your ability to deliver more professional solutions,
quicker than ever, in ways that would be nearly impossible to do
manually. Discover why so many developers and teams insist on using
Total Visual CodeTools to establish quality directly into their
processes.
Professional Coding Utilities
Total Visual CodeTools supports all VB6/VBA hosts, including Visual
Basic 6.0 (VB6), Office 2010, 2007, 2003, XP/2002, and
2000 (including Microsoft® Access®, Microsoft® Excel®, Microsoft® Word, Microsoft®
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 if you want
to obfuscate it
The tools are available directly in your module editor from the
menu or a dockable toolbar:

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
- Date Difference Builder to easily use the DateDiff builder
to compare two dates
Take the Builders Tour for more
details on each builder.
Additional Coding Tools
There are many other powerful tools to ease the
development process:
- 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.