ActiveXLS

VBA Code Decompiler and Compactor

This utility Decompiles and Compacts VBA code saved by Excel or Word, reducing the file size and the compilation conflict probability between different Office versions while also cleaning compilation garbage accumulated during the project phase that frequently generates errors and slows loading.

Useful for developers before file delivery and also for end users who experience problems when loading 3rd party VBA projects, because this utility can clean these projects without unprotecting the VBA project, from the closed file on disk and opened in an application environment free of the influence of add-ins, COM add-ins, and others pre-installed projects.

from ORLANDO’s VBA and EXCEL SITE

Add comment October 25th, 2006

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.

VBA Code Cleaner provides:

• The ability to strip comments, blank lines and spaces from your code
• The ability to retain the exported code files
• The ability to choose the locations to which backup files and exported code files are saved
• The ability to save all settings for each project you clean so that each time you clean a project the code cleaner will be preset for it

Add comment October 25th, 2006