View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 244
Default File size grows enormously

Thanks Norman.

The code cleaner does not solve my problem. I opened a 9mb
file, ran the codecleaner, and after saving it as another
filename, it was 16 mb.

Which recommendations of Debra do you mean? (Its not that
my system crash, the file sizes just keeps growing when I
save them)

-----Original Message-----
Hi Chris,

Three suggestions:

1. See Debra Dalgleish's recommendations:


http://www.contextures.com/xlfaqApp.html#Unused

2. Download Rob Bovey's CodeCleaner AddIn:


http://www.appspro.com/Downloads/CodeCleaner.exe

3. Use both of the above.


---
Regards,
Norman




"Chris" wrote in message
...
I have an Excel sheet with lost of VBA code in. This
includes forms. The file is about 3mb big. Recently, if

I
only include minimal code and save it, it will be 6mb,
next save :12 mb ect. I realised this after my computer
kept crashing, that my file is 120mb big!! please help!



.