my robot always stops working when the following window pops up while using the excel activity “remove duplicatesX”:
The robot continues when I click on any button or even when clicking on cancel. But until then, the robot gets stuck. When I put the debugger on the activitiy its just running endless if I don’t click anything on that popup.
I tried to implement an UIautomation to click a button if the popup apeears with the element exists activity but its not working because the robot gets completly stuck.
Opposed to using excel to remove duplicates you can store the data into a datatable using the read workbook range activity then use the datatable remove duplicates activity then store in a final DT, this means you will not have to use the excel application.
thanks for your answer!
The excel scope activity is needed for a number of other activities as well, so I was hoping that there may be a workaround to solve this. I just have to click the popup but since the code gets stuck when the popup appears, I cant achieve this.