View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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