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
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
October 25th, 2006
10. A sticker on the box reads, “Now Supports DOS 1.2″
9. It is part of a software suite called “Office Schmoffice.”
8. User testimonials on the box are written in Arabic.
7. The help file consists of three words: “Don’t ask me.”
6. The Setup diskette reads, “Disk 1 of 1″.
5. The Setup routine displays “Another Sucker” as the default user name.
4. The user manual is scribbled on the back of an old envelope.
3. The technical support phone number is 555-1212.
2. The only way to get a hard copy of your work is to photograph the screen.
1. When you press F9, a message box tells you to dig out your calculator.
via TheSpreadsheetPage
October 25th, 2006
“MicroCharts enhances Microsoft Excel and Microsoft Analysis Server with sparklines, bullet graphs and other in-cell charts.”
Great add-in, via DashBoardSpy
October 25th, 2006
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
June 25th, 2006
Next Posts
Subscribe to RSS