Re: A pathetic question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Alan - Cribbed from a post some time ago that Tom answered:-

[Quote]
What is there to explain? If you export a module as a file, then look at
the file size, it if it greater than 64KB, then, based on Rob's experience
and that of others, one may experience strange problems with the
application.

Since this is not a documented restriction, it would be hard to definitively
say what the exact restrictions are, but I would suggest that as a rule of
thumb, regardless of the type of module, keep the size to less than 64 KB.

--
Regards,
Tom Ogilvy


Stuart <sg_booth@xxxxxxxxxxx> wrote in message
news:ucqGC#ZaDHA.2928@xxxxxxxxxxxxxxxxxxxxxxx
> Within the last day or so Rob Bovey replied to an OP
> and included the comment that (sic) "a module should
> not exceed 64kb" ( I think that's what was said).
>
> Would someone be kind enough to explain the reasons
> behind this advice, please?
>
> Would this apply to all modules (Standard, Class etc),
> and would this equally apply to AddIns?
>
> Regards.

[/quote]

Regards
Ken...................


"Alan Beban" <unavailable@xxxxxx> wrote in message
news:O23dweYqFHA.3520@xxxxxxxxxxxxxxxxxxxxxxx
> Don Guillett wrote:
>> By all means, remove the empty modules and organize as desired. Just
>> don't
>> put too many procedures in one module. . . .
>
> Why is that?
>
> Alan Beban


.

Relevant Pages

  • Re: Rounding Entries From Range to Array
    ... misinformation and kudos to Alan for giving the correct response. ... Regards, ... Tom Ogilvy ... > project and only a single source of help, I could wish for nothing better ...
    (microsoft.public.excel.programming)
  • Re: Table Lookup (VLookup, Index, Match)
    ... Regards, ... > range and a column range, you can do what Alan suggest, substituting the ... > times slower or worse since you have to use Excel to evaluate the value. ... > Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: OT/ Sins of the Past
    ... Alan S wrote: ... >>> lets see you show a nasty post of mine before Ozgirl made ... Tom used "Cheeseburger" as one of his many ... they support the ADA. ...
    (alt.support.diabetes)
  • Re: Ron de Bruins copy5 code amendment
    ... exhausted what brains I have. ... > Hi Ron, ... >> regards, Alan ...
    (microsoft.public.excel.programming)
  • Re: OT/ Lower than a Snakes Belly
    ... Tom is a sick sick coward ... >>like I said - showing a picture of you is not ... > Alan, T2, Australia. ...
    (alt.support.diabetes)