Since we’re on the topic of Excel utilities lately, I figured I’d jump in with my announcement of a new major version of the Excel VBA Code Cleaner. Here’s a brief summary of what’s new:
- The code cleaner is now implemented as a COM add-in. This has significantly improved its speed and stability.
- I addressed the most commonly requested improvement by adding two new features: code module export-only and code module import-only. While not technically related to code cleaning, I’ve received numerous requests from users who want the code cleaner to assist them with Excel source code control.
- I addressed my second most common feature request by exposing virtually every function used within the code cleaner to COM automation. You can now use the code cleaner DLL to roll your own code cleaning and code management solutions.
- The code cleaner desperately needed a high-quality help file, and I finally wrote one for this version. The help file includes complete documentation of the COM interface, including examples.
Like previous versions, the code cleaner is free and source code is included. With this version, however, you’ll need a copy of VB6 to take advantage of the source code because that’s what I used to write it. The source code will be located in the installation folder in a file cryptically named VB6_SourceCode.zip.
You can download the new code cleaner from:
Please uninstall any previous versions of the code cleaner prior to installing this version. Comments and bug reports welcome.