View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Romuald[_3_] Romuald[_3_] is offline
external usenet poster
 
Posts: 6
Default Compiling Excel VBA code increases workbook file size!

hello,

I develop a big Excel workbook having more than 30000 code lines.
When I compile all the code from the VBE and save the worbook, the worbook
file size increases dramaticaly (from 3500Ko to 7000Ko). It seems that Excel
saves compiled objects.

Is it possible to avoid Excel keeping compiled objects in the saved file?

Thanks for your help!