是否可以将VBA表单作为.exe文件运行？ [英] Is it possible to run a VBA form as a .exe file

问题描述

是否有可能将表单保存为VBA作为.exe文件，然后运行它。 不，不是原生地。

有几种方法可以模拟EXE： b
$ b

• Excel ：宣称能够将工作簿编译为EXE的第三方工具： DoneEx XCell编译器。您也可以创建一个自动marco，Auto_Open，以便在打开工作簿时运行。


• 访问：Microsoft曾经有一种方式将Access数据库作为一个可执行文件（该工具的名称使我感到不安），因此您可以将数据库部署到未安装Access的桌面，但我认为他们不再提供此功能。您可以将MDB转换为MDE并将启动属性设置为隐藏数据库窗口和菜单等以模拟EXE，但您的用户需要安装Access。


• Word ：您可以在启动时将 / m 开关传递给Word，并使用要运行的宏的名称。
  
  
  

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

  解决方案

  No, not natively.

  There are some ways to emulate an EXE:

  • Excel: 3rd party tool that claims to be able to compile an workbook to an EXE: DoneEx XCell Compiler. You can also create an automatic marco, Auto_Open, to run when the workbook is opened.
  • Access: Microsoft used to have a way of delivering an Access database as an executable (the name of the tool escapes me) so you could deploy your database to desktops that didn't have Access installed, but I don't think they offer this anymore. You could convert you MDB to an MDE and set the startup properties to hide the database window and menus and such to emulate an EXE, but your users will need to have Access installed.
  • Word: You can pass the /m switch to Word on startup with the name of a macro to run.

  这篇关于是否可以将VBA表单作为.exe文件运行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！