excel vb size

Re: excel vb size


"Tom Wright" <[email protected] om> wrote in message
news:ictc10h31m 55ro2hed0t247ub [email protected] om...[color=blue]
> i have an excel spreadsheet with embedded vb. it's amazingly huge
> (600k to 900k).
>
> as i put in minor edits to the code or forms, it gets bigger very
> fast. for example, i added 2 buttons and about 5 lines of code for
> each (copied from elsewhere in the program) and it grew by 50k! i
> added a tab to a dialog element and moved a couple of controls from
> one tab to another and it grew by 100k!
>
> occasionally i'll make some tiny change ant it will shrink by 300k. i
> assume it's done some cleanup or compress operation.
>
> is there a way to force this cleanup when i want it so i can get the
> smaller version for distribution?
>
> thanks,
> tom
> san diego[/color]

Save As.

900k no longer seems "amazingly huge" to me. It seems like all MS files
are big these days...

Re: excel vb size

steve,

regretfully, Save As does not seem to be the ultimate solution. within
the last couple of days i've seen my save size vary randomly from 475k
to 950k even though i've been making no changes that should materially
affect the size. Save As took my current version from 657k to 655k,
quite far above 475k.

anyone have any further ideas?

tom

On Tue, 27 Jan 2004 18:25:18 -0800, "Steve Gerrard"
<notstevegerrar [email protected]> wrote:
[color=blue]
>
>"Tom Wright" <[email protected] om> wrote in message
>news:ictc10h31 m55ro2hed0t247u bep156fi0t@4ax. com...[color=green]
>> i have an excel spreadsheet with embedded vb. it's amazingly huge
>> (600k to 900k).
>>
>> as i put in minor edits to the code or forms, it gets bigger very
>> fast. for example, i added 2 buttons and about 5 lines of code for
>> each (copied from elsewhere in the program) and it grew by 50k! i
>> added a tab to a dialog element and moved a couple of controls from
>> one tab to another and it grew by 100k!
>>
>> occasionally i'll make some tiny change ant it will shrink by 300k. i
>> assume it's done some cleanup or compress operation.
>>
>> is there a way to force this cleanup when i want it so i can get the
>> smaller version for distribution?
>>
>> thanks,
>> tom
>> san diego[/color]
>
>Save As.
>
>900k no longer seems "amazingly huge" to me. It seems like all MS files
>are big these days...
>[/color]

Re: excel vb size

Not sure if VBA can use Control Arrays, but write a control array for the
buttons, maybe? And code it so they won't show up until they are needed? I
know it can be done in VB somehow, just not the actual execution of it.
Also, you could try writing the same code in VB (if you have it) and see
what the file size is there. If it's smaller and the other computer(s)
already has/have Excel, you might think of using OLE through VB instead of
strict VBA. Of course, that's a moot point if you don't have VB ....

Ken
undrhil@hotmail .nospam.com

"Tom Wright" <[email protected] om> wrote in message
news:i6if109j0a 7fetpeee98undca [email protected] om...[color=blue]
> steve,
>
> regretfully, Save As does not seem to be the ultimate solution. within
> the last couple of days i've seen my save size vary randomly from 475k
> to 950k even though i've been making no changes that should materially
> affect the size. Save As took my current version from 657k to 655k,
> quite far above 475k.
>
> anyone have any further ideas?
>
> tom
>
> On Tue, 27 Jan 2004 18:25:18 -0800, "Steve Gerrard"
> <notstevegerrar [email protected]> wrote:
>[color=green]
> >
> >"Tom Wright" <[email protected] om> wrote in message
> >news:ictc10h31 m55ro2hed0t247u bep156fi0t@4ax. com...[color=darkred]
> >> i have an excel spreadsheet with embedded vb. it's amazingly huge
> >> (600k to 900k).
> >>
> >> as i put in minor edits to the code or forms, it gets bigger very
> >> fast. for example, i added 2 buttons and about 5 lines of code for
> >> each (copied from elsewhere in the program) and it grew by 50k! i
> >> added a tab to a dialog element and moved a couple of controls from
> >> one tab to another and it grew by 100k!
> >>
> >> occasionally i'll make some tiny change ant it will shrink by 300k. i
> >> assume it's done some cleanup or compress operation.
> >>
> >> is there a way to force this cleanup when i want it so i can get the
> >> smaller version for distribution?
> >>
> >> thanks,
> >> tom
> >> san diego[/color]
> >
> >Save As.
> >
> >900k no longer seems "amazingly huge" to me. It seems like all MS files
> >are big these days...
> >[/color]
>[/color]