I would appreciate someone pointing me to somewhere where I can read up on compiling VBA code. I see "Compile" as an option on one of the drop down boxes when I am writing my code but have choosen not to use it until I fully understand WHAT I am doing, WHY I am doing it, and WHEN I should or should not do it? Any suggestion on where to look for this informaion?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Compiling VBA modules/procedures? Why? When?
- Thread starter jkoetter
- Start date
tusharm
MrExcel MVP
- Joined
- May 28, 2002
- Messages
- 11,029
What drop down box? AFAIK, "Compile {project name}" is a menu item (part of the Debug menu).
VB(A) is a language that is "compiled" into an intermediate form. That intermediate form is then interpreted at runtime.
Use it to your heart's content. It will do you no harm.
I use it regularly to syntax check my code.
If you don't explicitly compile the code, it will be compiled on-demand at run-time. Much better you do the needful in advance and ensure it is syntactically error-free.
There are some subtle issues involved with when one should compile the code and on what platform. But, I wouldn't worry about those advanced issues at this point.
VB(A) is a language that is "compiled" into an intermediate form. That intermediate form is then interpreted at runtime.
Use it to your heart's content. It will do you no harm.
I use it regularly to syntax check my code.
If you don't explicitly compile the code, it will be compiled on-demand at run-time. Much better you do the needful in advance and ensure it is syntactically error-free.
There are some subtle issues involved with when one should compile the code and on what platform. But, I wouldn't worry about those advanced issues at this point.
Upvote
0
L
Legacy 98055
Guest
Perhaps the OP is speaking of the "MakeCompiledFile Method"? The dropdown boxes known as intellisense? I'm fairly certain that this method is a lame duck unless you have the developer edition though the help files do not seem to indicate this or much at all for that matter...
Upvote
0
Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
If you're talking compiling Excel VBA to C++, check out http://www.turboexcel.com/
Upvote
0
why compile VBA
Because it'll catch some syntax errors and other missing items. It doesn't "compile" like a C compiler would create a .exe but it is useful. Of course if you don't use Option Explicit at the top of all your modules, you're also setting yourself up for many hard to find errors.
Deb
Because it'll catch some syntax errors and other missing items. It doesn't "compile" like a C compiler would create a .exe but it is useful. Of course if you don't use Option Explicit at the top of all your modules, you're also setting yourself up for many hard to find errors.
Deb
Upvote
0
Similar threads
- Question
- Question
- Question
- Question
