How to close the popup in the excel

Help Automation Ops
,
1

How to close the popup in the excel. There is a popup after the excel is opened, how to close it. Which activity is to be used.

2

Hi @anjani_priya

Can you try with Click activity

Regards,

3

It may appears or not, sometimes its appearing and in sometimes its not.
when it appears , it should close the popup

4

Hi @anjani_priya

Check the below threads

5

@anjani_priya

Use Check app state activity and then use click activity

Regards,

1 Like
6

@anjani_priya,

What kind of popup you are getting? Any screenshot.

7

image
image838×92 4.53 KB

8

I would say you first investigate why this pop up happen and fix the issue at the source. There’s an activity available which may be of help:

1 Like
9

@anjani_priya,

Is it appearing when opening the file?

10

yes, while opening the excel its appearing

11

@anjani_priya,

Follow these steps:

  1. Create a workflow to open the excel file using Excel Process Scope
  2. From your Process.xaml or whichever workflow you want to work on the data Invoke this excel file opening workflow. Make sure you are check boxing Isolated property of Invoke Workflow. Move this Invoke workflow to Parallel activity.

Like this.

The image shows a parallel workflow sequence in a UIPath design interface, with an indication to check the "Isolated" box in the "Input" properties of an "Invoke Workflow File" activity. (Captioned by AI)
The image shows a parallel workflow sequence in a UIPath design interface, with an indication to check the "Isolated" box in the "Input" properties of an "Invoke Workflow File" activity. (Captioned by AI)1033×421 34.3 KB

  1. In the same parallel activity add Use Application browser activity to handle the popup.

Try this and let me know in case of any issue.

Refer this thread also.

Thanks,
Ashok :slight_smile:

1 Like
12

Try to add pick branch or parallel activity and if pop up found you can have click ok activity or try to send ESC short cut key

Also try to disable the popup by advance excel setting as suggested in other replies

The other thing is try to launch excel file in read only mode by vb script
Open command
You can add invoke code and one liner script to open file in read mode @anjani_priya

13

The image shows a software interface error with code 0x800AC472 in an Excel file operation, highlighting the file path and settings related to saving changes and formatting. (Captioned by AI)
The image shows a software interface error with code 0x800AC472 in an Excel file operation, highlighting the file path and settings related to saving changes and formatting. (Captioned by AI)1434×454 13.9 KB

iam getting the error while opening the excel. I am unable to put the parralel

14

@anjani_priya,

You missed the excel file path. It’s just the directory you put there. Use full path there.

15

Yeah I have used just in the scrrenshot i have removed

16

@anjani_priya,

Here is working sample for your reference.

This image shows a UiPath workflow in a Parallel activity, performing two parallel tasks: running a sub-workflow file ("SubFlow.xaml") and interacting with an Excel application by executing a specific click action on a 'Cancel' button. (Captioned by AI)
This image shows a UiPath workflow in a Parallel activity, performing two parallel tasks: running a sub-workflow file ("SubFlow.xaml") and interacting with an Excel application by executing a specific click action on a 'Cancel' button. (Captioned by AI)1042×723 51.8 KB

SubFlow

An automation workflow is designed to open the Excel file "Book1.xlsx" and log the message "File Opened" at the info level. (Captioned by AI)

ExcelWork.zip (243.6 KB)

2 Likes
17

Is the subflow and main cant be in single workflow?

18

@anjani_priya,

No, It cannot because it’s require this way to isolate the UiPath Executer.

1 Like
19

I have used check app state inside I have used keyboard shortcuts with escape button

1 Like
20

Is it working ? Now with this as expected