Unanswered

UI Element not working

(0) Share

Report

Posted on by MosesL

Hi there, I am currently working on a flow where I will open multiple excel and amending columns in there, however the excel comes in protected view. I am trying to use UI Element to click my way to make the sheet "unprotected". The issue I am facing is that the UI Element does not work on the excel file it opens. I took the elements from a new Excel sheet, hence it is Book2. I tried editing the element to look for "CurrentItem" as the name of the Excel book but it is still not able to work. The error is "Failed to get window".

Any assistance is appreciated.

Screenshot 2023-11-02 105936.png Screenshot 2023-11-02 110009.png Screenshot 2023-11-02 111741.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Hi @MosesL !

You can try out the following flow:
So here I set the excel instance to be maximized and focused in the foreground. Instead of "Click UI element in Window" action, use the "Send mouse click" action. Since the "Review" tab, "Protect/Unprotect Sheet" button and the pop ups are fixed.
Error handling set to continue flow and "Go to next action".

This works fine on my end. Please do let me know if any error still persists. Hope this helps.

Regards,
Nathan Alvares
----------------------------------------------------------------------------------------------------------------------------------------
If this helps & solves your problem, please remember to give a "Thumbs up" and "Accept my solution" as it will help others in the future.

Was this reply helpful? Yes No
MosesL 9 on at

Like (1)

Report

Thanks for the assistance, I just learnt how to use OCR and decided to use that instead. Have a great day ahead!

Was this reply helpful? Yes No