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