| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA error - increased file size
Thank you. The file was instantly reduced in size and back to the normal
size. Was somewhat hoping it would be even smaller :) /T "Norman Jones" wrote: Hi Monshi Try Rob Bovey's CodeCleaner utility: http://www.appspro.com/Utilities/CodeCleaner.htm --- Regards, Norman "Monshi" wrote in message ... Did a test run of a VBA project in a Excel file. An error was found, a module deleted ande then the file was saved. The result was an increase of the file size by about 200 kB. (from 800 kB to 1000 kB, an increase by 25 %) So now I'm wondering how to remove these 200 kB and if there are more cached data in the saved file and if it is possible to reduce the file size by clearing this cache. Using Excel 2002, have control of Used range and a lot of VBA code. Yours /T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File size increased dramatically | Excel Discussion (Misc queries) | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| What increased my file size from 2mb to 5mb in a week? | Excel Discussion (Misc queries) | |||
| File size increased 7-fold! | Excel Discussion (Misc queries) | |||
| Excel file size increased | Excel Discussion (Misc queries) | |||
Threaded Mode
