I have an object that I've created that works sometimes and doesn't work others. After attaching and activating an Excel file, it sends send keys to Excel that cause popup windows to appear such as pivot table window, paste special window, filter window, go-to window, etc..
90% of all failures have been timeouts waiting for these windows. I have tried loops to gain control of the application, minimize/maximize, activate application, sleep stages, among many others. None of it seems to work consistently. If Blue Prism decides it can't see the popup window, it just can't see it.
Does anyone have experience with this issue and can offer a suggested solution?