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).
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).
