Question
1
Replies
14
Views
Infosys Ltd
Posted: December 16, 2019
Last activity: December 23, 2019
Closed
"Need to trigger VB script in excel using Pega
For our project, we have to trigger VB script implemented on an embedded ActiveX control in an excel sheet. Please share the steps to achieve this using Pega Openspan.
This won't be possible with just the Excel connector. You'll likely need to investigate using "Excel interop" in C#. If you can upload a copy of your spreadsheet, we might be able to take a look to see if there is a way to achieve this without using C#, however I do not believe so based solely on your description.
You might also be able to write a macro in Excel to trigger it. If so, you could call that macro from the Excel connector.