View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default What is a VBA Cleaner and why using it?

Bart,
The "junk" it removes is not visible to you.
The code you write is not directly read by the computer.
It is converted to a machine readable code during the compile operation.
This is not a perfect process and the module can become bloated.
The more changes you make to the code the larger the module can become.

Many people use the "Cleaner" add-in and are happy with it.
I have had some awful crashes using it and instead copy code to NotePad,
delete the module, insert a new module and then copy the Notepad text back
into the new module.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




wrote in message
Dear All,
Please, could anybody tell me some more details about the VBA Cleaner?
The fact a program like VBA Cleaner exists doesn't make sense to me.

The only explanation I get is the following:

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.

How do I have to imagine this "junk code"? I'm very tidy writing my
code.
Regards,
Bart