compiling VBA in Excel2000

C

Chip Pearson

VBA code exists in two states: OpCodes which is how generic VBA is stored in
files, and ExCodes which are interpreted at run time. The Compile operation
converts OpCodes to ExCodes. From a user standpoint, it is most useful as a
syntax checker (e.g., looking for undeclared variables).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
E

Edwin Tam (MS MVP)

However, after compiling your code, the file size is likely to be much larger.


----- Chip Pearson wrote: -----

VBA code exists in two states: OpCodes which is how generic VBA is stored in
files, and ExCodes which are interpreted at run time. The Compile operation
converts OpCodes to ExCodes. From a user standpoint, it is most useful as a
syntax checker (e.g., looking for undeclared variables).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error. in table-level validation expression in append query 0
Compile error in table level validation expression in ms access office 2019 0
Avoid compile error if userform doesn't exists??? 1
Recover Outlook calendar entry 1
Reference Outlook in Excel2003, but not working in Excel2000. 0
How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000 0
Space at end of multi page list to accommodate new entries 1
"Compile error in table level validation expression " after format 0

Top