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

8
Replies
2068
Views
 Pravallika M (PravallikaM465) Accenture Solutions Pvt Ltd Software Engineering Analyst
Accenture Solutions Pvt Ltd
IN
PravallikaM465 Member since 2016 53 posts
Accenture Solutions Pvt Ltd
Posted: March 8, 2017
Last activity: November 6, 2018
Posted: 8 Mar 2017 6:05 EST
Last activity: 6 Nov 2018 20:02 EST
Closed

Excel Macro Application integration in Openspan

Report

Hi,

Actually I wanted to use an Macro Enabled & password protected Excel Application(which contains forms button & many textboxes in it-PFA the screenshot for reference) in my openspan automation. How can I run that macro & interrogate the excel application buttons to perform click 0r other operations. so that the macro will generating some o/p data which I need to capture through openspan Automation. Please help me in this.

Regards,

Pravallika.


**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
Rajendra Prasad Ega
Posted: 6 years ago
Posted: 8 Mar 2017 20:44 EST
Jeff Badger (jeffbadger) PEGA Principal Product Manager, Robotics
Pegasystems Inc.
US
Report

The Excel connector does not support interrogating Excel forms.  Opening password protected files is possible but then you are not able to use the connector to work with them.  You can run macros from the connector though - see below.
Posted: 6 years ago
Posted: 22 Mar 2017 8:06 EDT
Pravallika M (PravallikaM465) Accenture Solutions Pvt Ltd Software Engineering Analyst
Accenture Solutions Pvt Ltd
IN
Report

In My Excel-Form There is Dropdown also there,based on dropdown selection,macro generates some result.How can I perform that in my automation?
Posted: 5 years ago
Posted: 18 Apr 2017 3:38 EDT
Pravallika M (PravallikaM465) Accenture Solutions Pvt Ltd Software Engineering Analyst
Accenture Solutions Pvt Ltd
IN
Report

Hi Jeff,

Suppose I want my macro to be applied globally on any type of excel sheet dynamically. How to achieve this?

Regards,

Pravallika.
Posted: 5 years ago
Posted: 18 Apr 2017 9:27 EDT
Thomas Sasnett (ThomasSasnett) PEGA Lead Robotics Architect
Pegasystems Inc.
US
Report

I think this is an Excel question more than a Pega one. Pega Robotics can execute a macro if it is present on a spreadsheet, however it likel cannot apply a macro for you to every spreadsheet. You might check with Microsoft to see if that is possible.
Posted: 5 years ago
Posted: 15 Nov 2017 9:04 EST
Ashok D (AshokD) Standard Charttered Bank RPA - Tech Consultant
Standard Charttered Bank
IN
Report

Hi Pravallika ,

i have the same doubt of what you post in above, have you done that part i'm also facing same problem, if it's so can you please guide me and one more i need to pass parameters like above of your user form
Posted: 5 years ago
Posted: 18 Apr 2017 21:49 EDT
Sudheer Thanna (thans2) PEGA System Architect
Pegasystems Inc.
AU
Report
Hi Pravallika, 1) Create a windows adapter and set the exe path which should point to the excel.exe. 2) Open the windows adapters properties, set the childhookup property to "true" and StartMethod propert to "MonitorAll". 3) Start the windows adapter and manually launch the macro enabled excel file that you wanted to interrogate. Now you will be able to interrogate all the forms which are being triggerred by the macros. 4) If you are not able to interrogate with the bulls eye, then go to the windows-> list windows option in the windows adapter to identify the specific form thta needs to be interrogated. Hope this answered your question. Thanks, Sudheer
Posted: 5 years ago
Posted: 19 Apr 2017 4:20 EDT
Sander Schouten (SanderS5) Ernst & Young
Ernst & Young
NL
Report

How can I overcome security warnings caused by a macro and activeX element in my Excel file when I open it with PegaRobotics? See screen shots attached.

This comment has been branched out as a new node and the new thread can be followed here
Posted: 5 years ago
Posted: 19 Apr 2017 4:24 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Report

Hello and welcome to PSC!

Since you have asked a related but new question on an existing post, we have created a new post for you! This will get your question more visibility. Please update the new post to continue troubleshooting! 

How can I overcome security warnings caused by a macro and activeX element in my Excel file when I open it with PegaRobotics?

Thank you!

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