Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 SATHISH KRISHNAMURTHY (SATHISHK7575)
Infosys Ltd

Infosys Ltd
IN
SATHISHK7575 Member since 2018 27 posts
Infosys Ltd
Posted: Dec 16, 2019
Last activity: Dec 23, 2019
Posted: 16 Dec 2019 6:31 EST
Last activity: 23 Dec 2019 8:09 EST
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.
To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 23 Dec 2019 8:09 EST
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice