Size of file changes when saved
 

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

Size of file changes when saved
 

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" wrote in message
...
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

Size of file changes when saved
 

Thanks for the info - very interesting !

RB Smissaert wrote:
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" wrote in message
...
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