Hi --

  I am developing an excel vba application. As I continue to edit and save, the size of the xls file continues to increase. It is now at 2 mb. If I export all the vba files and then reimport into a new workbook, the file size decreases to .5 mb and works just fine. Is there any way to prevent the increase? If not, is there any way to automate the export/import process?

Thanks,

Barry

Dear Barry,

Go to the site www.appspro.com and download the VBA Code Cleaner Add-in.
I used it for a couple of months now for cleaning very big Excel files
and never had any problem with this great programm.
By the way they have more great and free utilities.

Succes