View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1
Default 64kb limit to module code

How does one check, just the size of the module? If it
excedes 64 k, then is the best way to export it, not to
export it, but to maybe put the code in a word document
then copy it out to a "newly" establised module in the
exported Excel file?

Thanks,
David
-----Original Message-----
The 64kb problem would apply to addins as well.

--
Regards,
Tom Ogilvy

Stuart wrote in message
...
Ok so if a project contains modules 64Kb and that
project is saved as an AddIn, then ok.
If an individual module greater than 64KB were to be
exported from that AddIn, then problems.

Regards and thanks.

Tom Ogilvy" wrote in message
...
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 wrote in message
...
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system

(http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release

Date: 19/08/2003






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system

(http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date:

19/08/2003




.