Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Cleaner (Rob Bovey): Compile? Means what?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Cleaner (Rob Bovey): Compile? Means what?
"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 BEEJAY wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Cleaner (Rob Bovey): Compile? Means what?
"BEEJAY" wrote in message
... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code cleaner | Excel Discussion (Misc queries) | |||
HTML Code cleaner | Excel Programming | |||
Code Cleaner in 2003 | Excel Programming | |||
Code Cleaner | Excel Programming | |||
VB Code Cleaner | Excel Programming |