Code Cleaner (Rob Bovey): Compile? Means what?

G

Guest

Have just used this code cleaner on my largest code package.
When it was complete, the message comes up to Compile, Save, and restart
Excel.
I don't understand what is required by "compile".
Anyone?
 
D

dolivastro

"Compile" usually means to check code and, if correct, translate it to
machine language, in a file called the "Executable". In the case of
VBA code, however, there is no true executable file. So basically, it
is just checking your code.

If you have variables undeclared, subroutines with the wrong number or
type of arguments, etc, it should warn you about these.

Hope this helps,
dom
 
R

Rob Bovey

BEEJAY said:
Have just used this code cleaner on my largest code package.
When it was complete, the message comes up to Compile, Save, and restart
Excel.
I don't understand what is required by "compile".

Hi Beejay,

In this case the message means you should choose Debug/Compile from the
Visual Basic Editor menu before saving your file and restarting Excel. It's
mostly useful as a quick way of checking your code for basic syntax errors.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 

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

Top