View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Minimizing/Compressing VB Code in Excel File ...

Rob Bovey has documented this problem which relates to stripping in class
modules like ThisWorkBook and Sheet modules. It's particularly problematic
in XL97 but I've also had this problem in XL2K (not often).

In Options, check "Ignore code behind document objects when stripping"

Regards,
Peter T


"Joe HM" wrote in message
oups.com...
Hello -

Thanks so much for the feedback! I tried Rob's utility and it actually
exports the modules and then re-imports them. That reduced the size of
the file. Then I used it to strip out comments and spaces.

The only thing I noticed is that when I did the export and re-import
AND stripping at the same time, Excel crashed. Weird ...

Thanks again!
Joe