vba to exe: possible?

[sp]

It's possible to compile a vba code to obtain an .exe file?

 

[Rob Schneider]

It's possible to compile a vba code to obtain an .exe file?

With the product Visual Basic from Microsoft, this is possible. There
may also be 3rd party "compilers" out there. Check with Google, and
also check with the Visual Basic newgroups. Experts are there.

 

[Jezebel]

Experts are here, too. In the meantime here's my two bob's worth. The answer
is no.

You can create a VB project from a VBA project with greater or lesser degree
of difficulty and compile the VB; but you can't create an EXE from VBA.

Some VBA code can be transferred to VB relatively easily, but there are
quite a few VBA things that don't work in VB. In particular, UserForms don't
work in VB. If your VBA project has any forms you need to rewrite them. And
where VBA is always intrinsically related to the parent app (Word, Excel or
whatever), VB has to deal with the app as an independent object. Not
especially difficult, but you need to write the code to do it.

 

[Rob Schneider]

sorry ... I didn't notice which ng I was in when answered... thanks for
the clarification re vba vs vb and where experts are! My mistake. My
expereince is that all the vba I ever wanted to convert has done so
realtively easily (not the other way).