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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top