How to run an excel macro after it was opened using workbookproxy
How to run an excel macro after it was opened using workbookproxy like below
Thanks,
Arun
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
US
After a little digging I realized that the password protected file is not attached to the Excel connector when opened this way. The workbook opens but there is no way to switch it so it is under the Excel connector's control. Therefore, to run a macro you will need to extract a proxy from the workbook's Application property. This is available from Explore Component Properties in the Object Explorer. This proxy will have a Run method which allows you to run a macro from the workbook. It takes a macro name and up to 30 arguments. Send a System.Reflection.Type.Missing to any parameter you do not need.
Pegasystems Inc.
US
Use the RunMacro method of the connector.
http://help.openspan.com/80/Components/Using_the_Microsoft_Excel_Component.htm
Accepted Solution
Pegasystems Inc.
US
After a little digging I realized that the password protected file is not attached to the Excel connector when opened this way. The workbook opens but there is no way to switch it so it is under the Excel connector's control. Therefore, to run a macro you will need to extract a proxy from the workbook's Application property. This is available from Explore Component Properties in the Object Explorer. This proxy will have a Run method which allows you to run a macro from the workbook. It takes a macro name and up to 30 arguments. Send a System.Reflection.Type.Missing to any parameter you do not need.