本文介绍了如何使用Javascript代码运行Excel宏?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿
我可以使用JavaScript代码访问Excel工作表,但我想在该Excel工作表中调用或运行Macro ...
谁能帮我修复它.
提前致谢.
等待答复.
Hey
I can access Excel sheet using JavaScript code but I want to call or run Macro in that excel sheet...
Can anyone help me to fix it.
Thanks in advance.
Waiting for reply.
推荐答案
Private Sub Workbook_Open()
Run "Macro1"
End Sub
然后,无论何时打开工作簿,宏都会运行,无论您是自己从Excel,另一个Excel工作表还是通过Java等调用它.
希望对您有帮助,请投票表决!
Then whenever the workbook is opened, the macro will run, regardless of whether it is called by yourself from Excel, by another Excel sheet, or by java etc.
I hope this helps, please vote up if it does!
这篇关于如何使用Javascript代码运行Excel宏?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!