size/space problem with module1 in VB even though it is empty

M

mcpheat

Hi all

I have created a spreadsheet (xl97) using formulas, userforms and some
buttons spanning approx 7 worksheets. While new to vb, it's size seemed a
little large (740kb) and so I have done some investigating.

I first deleted the contents of module1 which decreased the file size to
624kb. I then progressively deleted all the worksheet contents (saving as I
went) until I got down to one worksheet and one with a number of charts on.
The filesize had progressively decreased to 382KB.

I then deleted my (empty) module1 and the filesize reduced to 93KB when
saved. Thats nearly 300KB stored in an empty module1. Can anyone shed some
light on the space waster for me.

Thanks
Tony.
 
J

Jan Karel Pieterse

Hi Mcpheat,
I then deleted my (empty) module1 and the filesize reduced to 93KB when
saved. Thats nearly 300KB stored in an empty module1. Can anyone shed some
light on the space waster for me.
Click to expand...

The VBE does a bad job cleaning up code that has been heavily edited. Much
of the stuff you changed/removed remains behind in the file somewhere.
That is why Rob Bovey has created his highly recommended Code Cleaner. Find
it at www.appspro.com or at www.bmsltd.ie/mvp

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Top