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!

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!

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!


.

John Walkenbach refers to this problem on his website.

The best way around it is:

1. Save a copy of the workbook (somewhere safe)
2. Remove all forms and modules (say YES to export them)
3. Save the workbook (not over that saved in 1 above !!)
4. close the workbook
5. Open the workbook in 3 above
6. import the forms and modules
7. Save the workbook.

This should result in a considerable decrease in size.

By the way - I have used this successfully for years, and
it always works
Good luck


-----Original Message-----
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!


.

.