| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel files saved to H drive are 0 byte size on initial save | Setting up and Configuration of Excel | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| ex03 file saved at 9000Kb. close immediately & size goes 16000kb | Excel Worksheet Functions | |||
| How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
![Andrew Bourke[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
