Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I used Rob Bovey's excellent codecleaner on an add-in and it reduced immediately from 700k to 500k a saving of 28%. What surprised me was that there was no further change (upwards) when I compiled the code, which I expected, having noticed this before on other files. Is this unusual for the compiled code to take no extra space? Thanks Tim |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Tim,
Yes, that is unusual. I don't think I've seen that happen before. I'd try compiling it again just to be sure it really took. If it still doesn't get any larger and it runs fine, you've got me. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Tim Childs" wrote in message ... Hi I used Rob Bovey's excellent codecleaner on an add-in and it reduced immediately from 700k to 500k a saving of 28%. What surprised me was that there was no further change (upwards) when I compiled the code, which I expected, having noticed this before on other files. Is this unusual for the compiled code to take no extra space? Thanks Tim |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rob
Thanks for response. Mea culpa! I forgot that when using XLA's that they do not prompt for a save when closed :) When i compiled the code the file had a size of 770kB which did surprise me, as it was 700 originally but not completely sure of it's compile-status at that point. sorry to mess you/the ng about THANKS Tim -----Original Message----- Hi Tim, Yes, that is unusual. I don't think I've seen that happen before. I'd try compiling it again just to be sure it really took. If it still doesn't get any larger and it runs fine, you've got me. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code cleaner | Excel Discussion (Misc queries) | |||
Cleaner Error trap in Loop. | Excel Discussion (Misc queries) | |||
somebody please email me Rob Bovey's code cleaner | Excel Programming | |||
Rob Bovey's Code Cleaner makes file larger. Why? | Excel Programming | |||
Excess Format Cleaner 1.0a locks up excel and vb editor | Excel Programming |