ActiveXLS

VBA Code Cleaner

October 25th, 2006

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

      

Entry Filed under: spreadsheet, vba

Related posts:

Remove the macro security warning

VBA Code Decompiler and Compactor

Why you shouldn’t use Office Automation