Geek Answers Handbook

Is it possible to run a VBA form as a .exe file

Is it possible to save the form in VBA as a .exe file and then run it.

+3
source share
4 answers

No, not originally.

There are several ways to emulate an exe:

  • Excel : a third-party tool that claims to be able to compile a workbook in EXE: DoneEx XCell Compiler . You can also create an automatic marco, Auto_Open, to run when you open the book.
  • Access . Microsoft had a way to deliver the Access database as an executable (the name of the tool escapes me) so that you can deploy your database on desktop computers that did not have Access installed, but I don’t think they offer this anymore. You can convert MDB to MDE and set launch properties to hide the database window and menu, etc. To emulate the exe, but your users will need to install Access.
  • The word . You can pass the /m switch to Word at startup with the name of the macro to run.
+4
source

I think there are at least 2 ways

move the code to visual base 6 and compile it or use the visual studio office tool and see what you can do.

if these 2 solutions are not for you, you're out of luck

+2
source

Not. VBA is a supplement to applications for supporting "scripting" in the form of VB. Therefore, if your application does not support the way to save the internal script as an external external EXE, you are out of luck.

0
source

I think DoneEx still needs to install Excel, it just loads something into an xls file or loads it, something, and exits it as exe ??? / ..

I think so. http://cpap.com.br/orlando/XLtoExeMore.asp

But at least the second, if free!

I have not tested a computer without an office.

what are you trying to do, maybe work in a different way?

thanks Ross

0
source

More articles:


All Articles