| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compiling doubles file size
I've been updating in 2003 an old 97-format template with a lot of VBA code.
If I compile it, the size doubles from around 500kb to 1mb. Why is it doing this? I've - unsurprisingly - decided not to compile it before saving but isn't this verging on the blasphemous? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
compiling doubles file size
Try copying all the sheets to a new workbook. then export your modules and
userforms and import them into the new workbook. See if that helps. -- Regards, Tom Ogilvy "Martin" wrote: I've been updating in 2003 an old 97-format template with a lot of VBA code. If I compile it, the size doubles from around 500kb to 1mb. Why is it doing this? I've - unsurprisingly - decided not to compile it before saving but isn't this verging on the blasphemous? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| Pasting/Compiling Data To The End Of A File | Excel Programming | |||
| Compiling Excel VBA code increases workbook file size! | Excel Programming | |||
| Comparing Doubles | Excel Programming | |||
| How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Linear Mode
