compiling VBA in Excel2000
 

What is it really about, there isn't any compiled com?

compiling VBA in Excel2000
 

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




"Juggernath" wrote in message
...
What is it really about, there isn't any compiled com?

compiling VBA in Excel2000
 

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




"Juggernath" wrote in message
...
What is it really about, there isn't any compiled com?