Compiling vba code as stand alone exe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm trying to locate a free or opensource compiler that would enable me to
compile some vba coding that I have done into stand alone exe. Can this be
done? if so, could someone point me in the right direction please.

Thank you very much!

Daniel P.
 
Hi Daniel,

Afraid not. VBA exists within a host application, and needs that application
to run it.

You could write your code in VB, using the VB product, but if that is
working on a workbook, then you will need to access that workbook via
automation, which is a bit trickier.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top