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

 Sean Bailey (SeanB897)
Nationwide Building Society

Nationwide Building Society
GB
SeanB897 Member since 2017 24 posts
Nationwide Building Society
Posted: Aug 13, 2018
Last activity: Nov 6, 2018
Posted: 13 Aug 2018 7:39 EDT
Last activity: 6 Nov 2018 20:02 EST
Closed

Opening Excel Workbook - Update links (Robotics Pega)

All,

I have a simple automation which opens a workbook and then proceeds to run a macro within the workbook. However the workbook contains links which causes a pop up when the excel document opens. (See screen shot)

I need to bypass this within the automation i.e. hit "Don't update" for the automation to complete. Can anyone recommend how I can do this?

Thanks

Sean

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago
Posted: 14 Aug 2018 17:14 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

You would need to interrogate that window in Excel (or at least see if you are able to). To do that, you'd need to create an adapter whose StartMethod is set to MonitorAll and whose Path is set to Excel.exe. This is because your connector is actually going to be starting Excel, so yor adapter cannot use any other StartMethod.

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