Reducing file size (for archiving, not active files)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have found that one way to quickly and easily reduce file size for a
Workbook that contains macros is this: Open the file; disable macros; save
the file. In some cases, I've seen around 20% file size reduction on 250k
files. Sadly, next time the file is opened and macros are enabled, the file
size jumps up again. Still, this could be a useful step before emailing or
archiving a document.

If interested in another way to reduce file size, please read my related
question in this newsgroup.

-Shadhi
.

Relevant Pages

  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... the Workbook with the hidden ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to be ... WkbkB's Macros will disallow editing except via Macro options. ... False, b) calls Application.SendKeys "e", c) opens ...
    (microsoft.public.excel.programming)
  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to ... references Hidden Cells in their Workbook Open Event). ... WkbkB's Macros will disallow editing except via Macro options. ...
    (microsoft.public.excel.programming)
  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... I think it's a mistake if you think that your suggestions will protect any ... Excel just isn't made for this kind of thing--no matter how hard you try. ... the Workbook with the hidden ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to be ...
    (microsoft.public.excel.programming)
  • RE: New clue! Open/Close other workbooks with VBA;
    ... You can also put a stop instruction in the workbook that is failing to ... isolate any problems with workbook open macros. ... File 1 opens and closes as expected. ... Dim secAutomation As MsoAutomationSecurity ...
    (microsoft.public.excel.programming)
  • RE: New clue! Open/Close other workbooks with VBA;
    ... You can also put a stop instruction in the workbook that is failing to ... isolate any problems with workbook open macros. ... File 1 opens and closes as expected. ... Dim secAutomation As MsoAutomationSecurity ...
    (microsoft.public.excel.programming)