本文介绍了如何使用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宏?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-28 21:55
查看更多