FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Visual CodeTools

Total Visual CodeTools manual

Microsoft Office Access 2010 Version
is Shipping

New Verrsion

Supports Office/Access 2010, 2007, 2003, 2002, 2000, and Visual Basic 6.0!

Also available for
Access 97


View all FMS products for Microsoft Access All Access Products

CodeTools Info:

Why CodeTools?

 

"Total Visual CodeTools is by far my favorite third-party product."

Alison Balter, Author, Conference Speaker, Instructor

More Reviews

Additional Info:

 

 

 
Create, Maintain, and Deliver better Microsoft Access, Office, VBA and VB6 code with Total Visual CodeToolsTotal Visual CodeTools for Microsoft Access, Office, VBA, and VB6Coding Tools for Microsoft Access, Office, VBA, and VB6 Download Trial of Total Visual CodeTools for VB6 and VBA/Office/Access

Unused Variable Analysis

The Unused Variable Analysis feature in Total Visual CodeTools helps you detect and eliminate unnecessary code from your VB6 and VBA projects including Microsoft Access, Excel, Word, etc. Quickly find code that's defined but never referenced or used. This includes:

  • Unused variables defined at the procedure, module, and project/global levels through Dim, Public, and Private statements
  • Unused procedure parameters
  • Unused constants
  • Unused classes
  • Unused user defined types and their elements

Unused code commonly occurs when changing existing code or eliminating previous code without noticing the variable definition remained. You fix this by simply deleting the variable definition.

However, this can also occur when you define a variable -- especially a procedure parameter -- then forget to use it. Maybe you wanted to track something or do something special based on a value but failed to do so. Rather than simply deleting the variable, you need to determine its purpose and make sure it's no longer necessary or implement it correctly.

Easy to Use

The Unused Variable Analysis is simple to use. Invoke it from the Total Visual CodeTools menu or toolbar, then select the objects to examine. It can be the entire project, one module, or one procedure.

Unused variable analysis for VBA and VB6
Example of selecting all modules from Northwind

Powerful Analysis

The powerful VB6/VBA code parser in Total Visual CodeTools examines all the selected modules to determine what variables, constants, etc. are defined. It also determines where they are used to see which items are never used. The list is provided in the results.

Results

Run the process and the results are provided in an HTML report:

Unused Variable Analysis in Total Visual CodeTools for VB6 and VBA

Review the results and fix accordingly.

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright FMS, Inc., Vienna, Virginia
Celebrating our 27th Year of Software Excellence