About the VBA Code Cleaner

During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files.

New in Version 5.0

•  COM Add-In - The VBA Code Cleaner is now implemented as a COM add-in. This significantly improves the speed and stability of the program.
•  Export Code Files - This feature allows you to export all the code files from a project to the directory you specify without the need to perform a project cleaning.
•  Import Code Files - This feature allows you to import all code files from a specified directory into the project you select.
•  Automation - All features of the code cleaner are exposed to VBA through COM automation so you can create your own applications using the code cleaner as a component.
•  Help File and Source Code - A dramatically improved help file is included with this version along with the complete VB6 source code used to create the add-in.

Installation Details

You must uninstall any previous versions of the code cleaner in order to use version 5.0. This can be done using the Control Panel > Add/Remove Programs applet. Having an earlier version of the code cleaner installed will not cause any harm, but earlier versions will hijack the menu used by version 5.0, preventing you from running the new version.

Download

Download the VBA Code Cleaner 5.0 (Build 5.0.28)

Version-Specific Notes

Note to Users of Excel 2002 and Higher Versions
You must set your security to trust access to Visual Basic projects in order to use the code cleaner. Choose Tools > Macro > Security from the Excel menu and click the Trusted Sources tab. At the bottom of this tab you'll see a checkbox labeled Trust Access to Visual Basic Project. Check this option and click OK to enable the Code Cleaner to run.

Note to Excel 2007 Users
In Excel 2007 the code cleaner can only be run from the VBE Tools menu. There will be no option to run the code cleaner from the new Excel 2007 Ribbon user interface.

Download the VBA Code Cleaner 4.4

  [ Home ] [ About AppsPro ] [ Books ] [ Free Utilities ] [ Tips and Tricks ] [ Links ]

  Copyright Application Professionals © 1999 - 2008