Size of file changes when saved

[Andrew Bourke]

Hi
I have an xla file in which I update macros from time to time.
I notice sometimes that when I save the file and then check the file
size in windows explorer, the file save size varies quite a bit.
Currently it is 270K but yesterday when I saved the file, it was less
than 200K - I had only adjusted three or four lines of code.

I'm just interested if anybody knows why this happens ?

TIA

Andrew B

 

[RB Smissaert]

Bit hard to explain what exactly happens (in simple words it is rubbish
building up in the file),
but I know how to fix it.
Download the CodeCleaner and run that:
http://www.appspro.com/Utilities/CodeCleaner.htm

RBS

 

[Andrew Bourke]

Thanks for the info - very interesting !

Bit hard to explain what exactly happens (in simple words it is rubbish
building up in the file),
but I know how to fix it.
Download the CodeCleaner and run that:
http://www.appspro.com/Utilities/CodeCleaner.htm

RBS