Office Javascript API - Excel Addin - 运行Excel宏 - 存储在工作簿中 [英] Office Javascript API - Excel Addin - Run Excel Macro - Stored in Workbook
问题描述
嗨朋友们，
Hi friends,
我的工作簿中有一个excel宏
sales.xlsm
I have an excel macro in my workbook
sales.xlsm
让我们称之为 MacroTest1
lets call it MacroTest1
< script type =" text / javascript">
<script type="text/javascript">
函数CallVBA （MacroName）
function CallVBA(MacroName)
{
var ExApp;
var ExApp;
ExApp = new ActiveXObject（" Excel.Application"）;
ExApp = new ActiveXObject("Excel.Application");
ExApp.Run（MacroName）;
ExApp.Run(MacroName);
}
CallVBA（" ; MacroTest1"）;
CallVBA("MacroTest1");
< / script>
</script>
HTML按钮
< input type ="按钮" onClick =" CallVBA"
value ="运行Excel宏" />
<input type="Button" onClick="CallVBA" value="Run Excel Macro"/>
如何从WebBrowser控件调用VBA宏？
How do I call a VBA Macro from a WebBrowser control?
我如何才能完成这项工作
- 我搜索了一周但仍然无法使其正常工作
How can i make this work - I have searched for a week and still cant make it work
我想运行已存储在工作簿中的宏。
I want to run my macro that is already stored in my workbook.
:(
推荐答案
您好，
在我的选项中，这是不可能的。
In my option, it is impossible.
对于Office加载项，没有api可以运行Macro。
For Office Add-ins, there is no api to run Macro.
对于ActiveXObject的当前方式，有一些限制。浏览器需要启用运行js代码，它将调用最终用户Excel应用程序来运行宏。这是普通Web应用程序中的常规方法。
For your current way by ActiveXObject, there are some limitations. The Browser will need to enable run js code which will call end user Excel application to run macro. This is the normal way in a normal Web application.
但是对于可以在桌面，Office Online等上运行的Office加载项，工作簿已经打开，我想你无法在ActiveXObject中再次打开它。
But for Office Add-ins which could run on desktop, Office Online, etc. The workbook has been opened, I think you could not open it again in ActiveXObject.
这篇关于Office Javascript API - Excel Addin - 运行Excel宏 - 存储在工作簿中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
