Connect HomeMarketplaceComponentsSopra Steria - Linked Workbook Pop-up Handler

Sopra Steria - Linked Workbook Pop-up Handler

Snippet

Snippet

Updated: October 24th, 2020

Published: August 19th, 2020

Downloads: 5

Industry: agriculture-forestry-fishing-and-hunting

Language compatibility: C#, Visual Basic

Community Support

Sopra Steria - Linked Workbook Pop-up Handler

Snippet

Summary: 

When a linked workbook is opened using Excel application scope, a pop-up appears and this Snippet will automatically click on the pop-up and perform further tasks

When a workbook is linked to another workbook, and this workbook is opened using Excel application scope, a pop-up appears asking the user to confirm if they want this workbook to be updated or not. Unless the user clicks on either of the buttons, further tasks in the workflow are not executed as the Bot is in pause state and waiting for the pop-up to disappear.
This Snipppet will take input from the user in the form of arguments and will click on either of the buttons. The user needs to provide input (Update or Don't Update ) and if the workbook provided is the linked workbook, then the Bot will click on the button based on the user's input and thus the Bot will not enter the pause state. The bot will perform as normal if the workbook indicated is not a linked workbook. Hence this Snippet can be used with any type of workbooks (linked or non linked).

The user needs to provide input as:
  • Update
  • Don't Update

If the the input provided is anything other than these then the bot will throw an exception.

Details

Benefits

While using Excel application scope for linked workbook, the BOT will not pause when the pop-up appears. 

Compatibility

UiPath.Excel.Activities: 2.8.5,
UiPath.Mail.Activities: 1.8.5
UiPath.System.Activities: 20.4.0
UiPath.UIAutomation.Activities: 20.4.1

Dependencies

UiPath.Excel.Activities: 2.8.5,
UiPath.Mail.Activities: 1.8.5
UiPath.System.Activities: 20.4.0
UiPath.UIAutomation.Activities: 20.4.1

Licensing

By clicking download you agree to the following license.