ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB Code Cleaner (https://www.excelbanter.com/excel-programming/284414-vbulletin-code-cleaner.html)

Tim Childs[_6_]

VB Code Cleaner
 
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

Rob Bovey

VB Code Cleaner
 
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




Tim Childs[_6_]

VB Code Cleaner
 
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/



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com