Sign In
Create your first automation in just a few minutes.Try Studio Web →
Sopra Steria - Linked Workbook Pop-up Handler
by YouTube
0
Snippet
<100
Summary
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
Overview
Overview
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.
Features
Features
While using Excel application scope for linked workbook, the BOT will not pause when the pop-up appears.
Additional Information
Additional Information
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
Code Language
C#, Visual Basic
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.1Updated
September 1, 2020Works with
UiPath.Excel.Activities: 2.8.5, UiPath.Mail.Activities: 1.8.5 UiPath.System.Activities: 20.4.0 UiPath.UIAutomation.Activities: 20.4.1
Certification
Silver Certified
Support
UiPath Community Support
Similar Listings
