Total Visual Code Tools(英語版)
開発チーム全体で一貫性のあるコードを記述できるようにするツール
FMS 社の製品
2003 年より日本国内にてComponentSourceで販売中。
開発チーム全体で一貫性のあるコードを記述できるようにするツール
Total Visual Code Tools は標準を保証して、コーディング時間を減らして、そしてエラーを削除するのを手伝うためにプロフェッショナルなコード中心のツールのコレクションとユーティリティーです。継承されたプロジェクトの中でコード化をクリーンアップするために理想的です:自動的にエラーハンドリングを加えて、フォーマッティングを標準化して、可変ネーミング規定を適用するなどします。。VB IDE に統合され、Total Visual Code Tools は全部の開発チームがコーディング標準の一貫したセットを共有して、そして実施することを可能にします。
Total Visual CodeTools provides a robust set of tools to help you in the day-to-day development of Visual Basic (VB) and Visual Basic for Applications (VBA) code. The main features of Total Visual CodeTools are:
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:
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
Inserts 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 it.
Total Visual CodeTools provides several useful builders for your day-to-day development efforts. These builders allow you to automate and simplify the following processes:
Procedure Builder
This builder allows you to quickly create new procedures that adhere to a set of standards that you define. It allows you to specify comment headers, error handling, indentation, naming conventions, and global procedure identifiers.
Property Builder
You can write property procedures in VBA that allow you to define properties of the objects you define in class modules. The process of creating such procedures can be difficult. You can use the Total Visual CodeTools Property builder to quickly build the property procedures necessary to implement a property in a class module.
Long Text/SQL Builder
Adding long SQL strings into a module and easily viewing it usually requires breaking it into a multi-line statement. The SQL Builder automates this by automatically converting a SQL string to a series of VBA lines that assign the string to a variable. Like SQL text, you may need to assign a long text string to a variable in your code. The Long Text Builder takes a string and automatically generates the multi-line code necessary to assign the text to a variable.
Message Box Builder
Message boxes are a common feature in VBA driven applications. Unfortunately, VBA does not provide tools for visually creating message boxes. Even experienced developers need to refer to the manual or help system to determine the values of icons and button options. The Message Box builder lets you visually create a message box statement or function.
Recordset Builder
Creating recordsets against a table or stored procedure is another of those routine tasks, which could be error prone. The SQL Builder generates code for you depending upon your chosen table object or stored procedure object.
Select Case Builder
Typing Select...Case statements can be a tedious process, especially when there are many conditions. The Select Case Builder allows you to quickly create such statements.
Code Delivery provides the tools for the final preparation of your code before distribution. Easily add line numbers to all of your code so you can take advantage of VB/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. Code Delivery provides the following code operations: