Nope... you can not make and installable stand alone program. VBA only works
with existing programs. What compiling will do is it will check all of your
syntax and point our any errors in the syntax. You should always compile your
code. If it does not compile then you need to fix it even if it seems to be
running ok. Note that a compiled program can still generate run time errors
so you still need to use error handlers.
--
HTH...

Jim Thomlinson


"Dave Marden" wrote:

I am wondering what Compile VBA project does. I have a regular Excel
project with quite a bit of VBA being used, and I am wondering mostly if
this will compile my project into a installable program.


Thanks,
Dave Marden