Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code module? | Excel Worksheet Functions | |||
code won't run from a module | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |