Trying to click "File" tab after "enable editing" button in excel which has opened in protected view (looking for a solution except for disabling protected view)

Help Studio
, ,
1

Hello everybody,

Need to click file tab after clicking Enable editing as below,

But I’m getting an error (“Invalid Ui Node”)

image
image906×149 26.3 KB

Any idea how to solve this?

Thanks in advance

1 Like
2

@lakshman @Palaniyappan

1 Like
3

@Zeki_Berk_Gokkaya

Welcome back to our UiPath community.

May I know where you are getting this error ? Can you please share screenshot of the error. So that we can check and help you.

4

image
image707×640 19.2 KB

image

5

image
image675×553 46.2 KB

6

Hi

Welcome back to UiPath forum

You were almost done

Make sure you have used a ATTACH WINDOW activity and choose the whole excel screen as a element
Once after selecting check the selector and replace the dynamic attribute with wildcard * symbol

and inside that attach window activity use this click activity

Hope this would help you resolve this

Cheers @Zeki_Berk_Gokkaya

7

Thanks for the hint, but I have already used an attach window activity

1 Like
8

Hmm
Try with click image activity where drag the file button as a region of image

@Zeki_Berk_Gokkaya

9

Do you think click image activity is a robust solution?

10

Usually excel application and with few of its button or fields, UI based activities will fail

In that case there are three options to handle it

  1. We can use hot keys
    Use send hot keys activity and use appropriate key combination to access the menu in a open excel file
    And that is absolutely possible as there are many key board shortcuts for excel

  2. We can use image based activities like click image
    Ofcourse it is less reliable
    But when it comes to excel it is reliable to certain extent

  3. Third you can try with COMPUTER VISION activities

Try in these order

Hope this would help you

Cheers @Zeki_Berk_Gokkaya

11

Hi @Zeki_Berk_Gokkaya ,

Could you pls try with different ui frame work to indicate the File tab in excel. I have done this automation long back by changing the ui framework (using F4 while indicating the ui) to resolve the invalid ui node error. Could you try once before going for image automation which is not reliable. Thanks.

12

Is this method of HOT KEY working…

@Zeki_Berk_Gokkaya

13

Unfortunately, it is not working.

It throws an error “Ui element is no longer valid”

14

Fine

Whenever we are using hot key with excel use in the below order

  1. Use a attach window and select that excel application a target element

  2. Inside the attach window use send hot key activity without any element indicated
    Just hot keys

Cheers @Zeki_Berk_Gokkaya

15

It is what I did but not working

16

It still throws an error, I guess the problem is because excel is opened in protected view.

It works when I disable protected view.

When it is opened in protected view, somehow unable to enable editing, even if it clicks enable clicking button