Close popover
Michael Tan (tanm1)
Sr. System Architect
Pegasystems Inc.
tanm1 Member since 2016 39 posts
Posted: May 18, 2017
Last activity: November 6, 2018

Pega Robotics Studio 8: interrogating Office (Excel) menu ribbon

Is it possible to interrogate and hence operate within automations the controls in the ribbon of Excel or any other Microsoft Office 2013 application?

If not, is there any other way, apart from SendKey, of achieving this - e.g. using the Microsoft Office Connectors?

If not, is there a way of using SendKey with HideApplicationAtRuntime set to true?

If not, is there a way of running automations on screen locked terminals with HideApplicationAtRuntime set to false?

Our client has very many use cases which distill to this requirement - e.g. they need to automatically save attachments from emails in Outlook as well, and they need to both read from and write to Excel documents with embedded VBA scripts which need to be executed as part of automations.

**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.

Robotic Process Automation
Moderation Team has archived post