Ribbon Commander (RC): VBA Code Cleaner Quick Tutorial

Does your VBA program behave erratically or stops with an incomprehensible error? VBA is a terrible housekeeper. As you edit your source code over time, the size of the file grows in ways that make no sense and the bloat makes its way into the add-ins you compile. Eventually, it can make your add-ins unstable: weird errors crop up, stuff that makes no sense and that you can't fix in code because it's not the code that causes the problem.

Ribbon Commander offers the .CleanVBAProject method, which can remove all code garbage from any macro-enabled or binary workbook and add-ins instantly.

The Ribbon Commander VBA cleaner removes all redundant caches from closed files, so VBE doesn't get a chance to replace the information.

Cleaned files are smaller in size. Nowadays files are moved between desktops and the cloud more frequently than ever before. On an enterprise level, compressed files translate into decreased costs for online storage and bandwidth. Backups and downloads can be executed faster. Email bounce-backs could be stopped and email storage requirements could be reduced.

For years the 'golden' standard for Excel VBA code cleaning has been module export - import. Ribbon Commander aims to raise the bar by offering several productivity advantages for VBA developers.

Ribbon Commander's VBA Project code cleaner supports both 32 & 64 bit versions of Office/Excel.

The .CleanVBAProject method does NOT open files in Excel. This translates to significant time savings, as massive workbooks may require even minutes to open and save.

Multiple closed files can be cleaned very fast by Ribbon Commander. Check if your files are already clean using the .isVBAProjectClean property.

Traditional cleaning involves exporting all VBA components to text files on disc. This a loophole for the security minded, as these text files can be undeleted easily by file recovery software.

Ribbon Commander's Code Cleaner can read and clean both unlocked & locked VBA projects. End users can clean 3rd party protected add-ins, when stability issues are experienced during loading or running code. Locked VBA projects are not unprotected under any circumstances.

Ribbon Commander's Code Cleaner can clean closed macro-enabled (.xlsm), binary (.xlsb) workbooks, templates (.xltm) & add-ins (.xlam) or any macro-enabled Office file (PowerPoint presentations & Word documents).

https://www.spreadsheet1.com/vba-project-code-cleaner-for-access-excel-powerpoint-word.html

http://www.ribboncommander.com/