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

[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?

 

[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

 

[Rob Bovey]

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