ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cleaning Up (https://www.excelbanter.com/excel-programming/380366-re-cleaning-up.html)

Bob Phillips

Cleaning Up
 
Code does bloat a file.

Try using Rob Bovey's Code Cleaner periodically,
http://www.appspro.com/Utilities/CodeCleaner.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rocks" wrote in message
...
Hello,
I recently was able to recover my Excel VBA Module from a corrupted Excel
File using OpenOffice Calc Application. After saving it back to an Excel
File I went back in and found every part of the File intact. I did notice
though that the size of the file was reduced in half, from 5.6 meg to 2.8

meg.
My question is,
Did my Code while running create all the extra size?
Is there a piece of code that I can append to the end of my program to

clean
up before exiting?

Thanks,
--
Rocks





All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com