Is there a way to compile an executable file in the Visual Basic editor that comes in Word and Excel?
2007-01-30 11:02:54 · 4 answers · asked by bauer 1 in Computers & Internet ➔ Programming & Design
No.
2007-01-30 11:06:02 · answer #1 · answered by ciscoan 5 · 1⤊ 0⤋
Since I am a contrarian I will answer YES.
Actually, the answer is NO, you cannot compile Visual Basic for Application (VBA) code. VBA is the Visual Basic editor that comes when you press ALT+F11 in Excel. (But you knew this already.)
HOWEVER, you can definitely create a Visual Basic executable using Visual Studio that would re-use Excel as if it was a library. Excel is a COM object and as such is fully re-usable in C++, in Delphi, in VB.NET or in C#...
Why people don't use these capabilities more is beyond me...
2007-01-30 22:20:52 · answer #2 · answered by identity341 2 · 0⤊ 0⤋
DEFINATELY NOT, IN FACT - IT IS VBA WHICH WORD & EXCEL INCORPARATE - NOT LIKE VISUAL STUDIO, FROM WHERE YOU CAN MAKE .EXE FILES.
Get a copy of Visual Basic 6.0 downloaded from Bearshare and enjoy the fun you can have for free!
2007-01-30 19:13:22 · answer #3 · answered by Kewl Dude Ganda 3 · 0⤊ 0⤋
No
You have to have the entire VB programming world.
2007-01-30 19:13:43 · answer #4 · answered by Anonymous · 0⤊ 0⤋