Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

.BAS to .EXE

Status
Not open for further replies.

Naffoussi

Structural
Mar 19, 2012
204
Hi All,

I want to convert a macro.bas compiled with Visual Basic for Applications into .exe file.
Anyone know how to do this? and how to reference some external program like Excel...

Thanks in advance,



Seif Eddine Naffoussi, Stress Engineer
33650 Martillac – France
 
Replies continue below

Recommended for you

Have you done a websearch?



TTFN
faq731-376
7ofakss

Need help writing a question or understanding a reply? forum1529

Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
 
Hi IRstuff,

Thanks for the quick answer. I've already done a web search and found some online compiler and some free downloadable like JustBasic, FreeBasic.

But I think the DoneEx is more easy to use. I will try it this WE.



Seif Eddine Naffoussi, Stress Engineer
33650 Martillac – France
 
I hadn't heard of DoneEx, but from a very quick review I'm impressed.

It compiled a worksheet with some fairly complex UDFs quickly and easily, and they seemed to work as intended. It even compiled some functions linking to Python, through ExcelPython, which I really didn't expect to work.

The evaluation version does not let you protect or hide the VBA code, so I can't say how well that works.

The only down-side is that the created exe files are much bigger than the originals, but for a compiler working without a special run-time package, I think that's probably inevitable.

It will be interesting to see how performance compares with the original un-compiled VBA.

Doug Jenkins
Interactive Design Services
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor