Compile VBA forms into exe?

[AncientTiger]

Just out of curiosity, is there a way to export and compile VBA projects? Is there something in Win2000/XP that does this, or something that I'm not seeing in the Office2000 suite?
------------------------------------
18 years of programming, and still learning every day!

 

[CubeE101]

Yes...
You can export them into DESIGNER forms...
Then compile them with VisualBasic 5/6/.net
They will import as a DESIGNER form... and you will NOT have the same options as you do with VB forms... but YES you can compile and make an EXE out of a VBA form, etc... using (real) Visual Basic.
(Note one advantage of using Real VB from the start is a right click menu (Copy, Cut, Paste...) on text boxes... this is not a standard option for Designer Forms) Sometimes... the BASIC things in life are the best...

or at least the most fun ;-)
-Josh Stribling

 

[AncientTiger]

Ok... so is there a way to do this if you don't have the Visual Basic editor?
------------------------------------
18 years of programming, and still learning every day!

 

[CubeE101]

No...
You Have too purchase Visual Basic Development package to make EXEs...
The concept is you can sell EXEs and make profit...
VBA is designed for Macros... You HAVE to have Word, Excel,... to be able to use a VBA macro since it is stored within the Document...
If you were Able to generate EXEs from within Office VBA... there would be no need for VB Development package... (Microsoft is not dumb... and Bill Gates OBVIOUSLY likes the money...)
VBA is very powerful... but it is still a tease...
after using VBA for a while you WILL want to be able to make stand alone programs...
For the simple fact that Not Everyone Has MSOffice...
On the flip side... If you purchase VB Dev... You "Could" make your "Own" Office Suite... Given, you had the skills to know how...

So to sum it all up... No VBA has NO compiling capabilities...
They want you to LIKE VBA so you will BUY VB Dev...
VBA is like a permenant Trial Version with Limitations.
VB Dev is worth every penny... I highly sugest the purchase...
It has virtually NO limitations. Sometimes... the BASIC things in life are the best...

or at least the most fun ;-)
-Josh Stribling

 

[AncientTiger]

Ok... worth a shot anyways.

Thanks
------------------------------------
18 years of programming, and still learning every day!