VBA Compiler

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

To Anyone,

Is there such a thing as a VBA Compiler, or is there a
package that can make a VBA program run faster

Burt
 
Your VBA code is compiled either when you "Compile ProjectName" from
the Debug menu in the VBA editor or when you first call a given
Function. Thereafter (until you change something) the compiled version
is used, as it always is in a .mde, where the source code has been
stripped out. Generally speaking, the performance bottlenecks in an
Access Application are in the database manipulation parts rather than
in your VBA code. Attention to database structure, indexing, and the
like, is much more likely to pay performance dividends than optimising
the compilation of the VBA code.

To Anyone,

Is there such a thing as a VBA Compiler, or is there a
package that can make a VBA program run faster

Burt
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
They likely were asking whether you'd gone to the Debug menu in the VBEditor
and selected the top option. That will help identify syntax errors, or
certain problems such as missing references.
 
Back
Top