LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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




.

 
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 module? Kat Excel Worksheet Functions 2 January 10th 09 03:10 AM
code won't run from a module Geoff Excel Discussion (Misc queries) 3 February 20th 07 08:08 PM
Unprotect Code Module in Code Damien Excel Discussion (Misc queries) 2 April 18th 06 03:10 PM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
copying vba code to a standard code module 1vagrowr Excel Discussion (Misc queries) 2 November 23rd 05 04:00 PM


All times are GMT +1. The time now is 02:03 AM.

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"