Excel: how to make OpenRPA open a specific file and push a few buttons

Hi,

new to this OpenRPA tool. I need to open a specific excel file and make the robot push a few buttons. I used the Start Process activity to open the file and then Get Element Windows and recorded what needs to be pushed exactly via mouse clicks. I even changed the mouse setting for thie activity not to make it a virtual click. The issue is that when I run the robot it shows instantly after opening the file that item was not located (the button which needed pushing that is).

or if you can explain to me how to make shortcuts key stick to an excel window. I know how to record a shortcut key but even with that I still keep getting the same error that item was not found.

Do you want to open an excel file ?? and what do you mean push a few Buttons?

Read Range and other excel activities, all have a select workbook button, and they will then open the excel file, so I think most people are a little confused about the question.
Also, it would help if you could explain what buttons you want to press, maybe there is a better way ( office is really hard to automate using the UI since it keeps adding/remocing panes )

Hi @Allan_Zimmermann ,
What I was going for is to open an Excel file (it worked via StartProcess activity) and then I wanted the robot to push on the Data ribbon the “Update all” button (it eventually worked find via Get Element activity and Recorder.

1 Like

Hi @Daniel_McNulty,
Yes, opened an excel file. I gave more details in my reply below to Allan. By “push a few button” I meant for the robot to do actual virtual clicks. I was able to resolve that via tries and errors, but everything is ok now.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.