I have developped a full export/import from Excel and it works. But this
action must be runned under excel XP. Unfortunately my workbook must be
compatbile with Excel 97. If I open the rebuild workbook directly with Excel
97, I cannot unprotect worksheet since Excel 97 doesn"t know Excel XP
encryption algorithm. So I have found a way to redefine the encryption
algorithm used in my workbook. This method applies well to sheets protection
but not to VBA code protection. Althoug I have define an encryption algorithm
use by Excel 97 (XOR), I cannot deprotect VB code. Moreoever, when I build
the new worbook and define the references, I meet problem with the DLL's
version used.

So I have to use the following process tu rebuild my workbook :
- rebuild workbook under Excel XP
- open workbook under Excel 97. Then correct references and define VBA
protect password.
- open my workbook under Excel XP to protect sheets.

It works, but i's tiresome and semi -manual :)

So If I fnid a way to clean compiled objects, it will be heaven! :)

thanks for your answers!





"deko" wrote:

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?

Can you do a full export/import with Excel? In Access this is a fairly
well-known issue. To fix it in Access, I create a new database, then go to
File = Get External Data and import everything from the original database.
The size of the mdb reduces by more than half, depending on how much coding
I've done.