View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default Minimizing/Compressing VB Code in Excel File ...

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