如何从命令行调用VBA方法 [英] How to call a VBA method from the command line

问题描述

我有一个用Access编写的应用程序。  我现在需要从批处理文件中调用应用程序中的一些逻辑。  如何从命令行调用VBA方法？

我一直在尝试使用VBS脚本和cscript命令使其工作，但我不知道如何引用应用程序名称（"Our_Application.application"）。  我是否在正确的道路上？

解决方案

从.bat档案中运行宏

< pre class ="prettyprint lang-vb"> cd\

c：

cd program Files

cd Microsoft Office

cd Office15

Msaccess.exe" c：\database.accdb" / x"MACRO NAME"
Msaccess.exe" c：\database.accdb" / compact

暂停

来自图库的示例：

https://code.msdn.microsoft .com / office / How-to-schedule-VBA-Macros-f09ceca9

I have an application that was written in Access.  I now have need to call some of the logic in the application from a batch file.  How can I call a VBA method from the command line?

I have been trying to get this to work using a VBS script and the cscript command, but I don't know how to reference the application name ("Our_Application.application").  Am I on the right path?

解决方案

Run a macro from a .bat archive

cd\

c:

cd Program Files

cd Microsoft Office

cd Office15

Msaccess.exe "c:\database.accdb" /x "MACRO NAME"
Msaccess.exe "c:\database.accdb" /Compact

pause

An example from gallery:

https://code.msdn.microsoft.com/office/How-to-schedule-VBA-Macros-f09ceca9

这篇关于如何从命令行调用VBA方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！