Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 811
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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/

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code cleaner WH99 Excel Discussion (Misc queries) 7 July 18th 08 09:15 PM
Cleaner Error trap in Loop. plys Excel Discussion (Misc queries) 3 January 20th 07 03:31 AM
somebody please email me Rob Bovey's code cleaner Tim Zych[_5_] Excel Programming 1 October 16th 03 08:08 PM
Rob Bovey's Code Cleaner makes file larger. Why? Don Wiss Excel Programming 1 October 8th 03 07:23 AM
Excess Format Cleaner 1.0a locks up excel and vb editor Tom Ogilvy Excel Programming 0 September 18th 03 06:11 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"