Help with Excel Pop Up's in my Sequence

Help Studio
1

Hi - looking for some help. I’m new to UiPath / RPA. I’ve started a sequence with Excel Application Scope, I’ve mapped the file location and added in a Image Exists and If Condition as there is a pop up when you open Excel. However, when I run the debug function, it searches for the image before opening excel?
Can you anyone explain why it’s doing this?

2

Yes @amrit.karwal

Excel application scope will open the excel within milliseconds and goes to the inside activities of the Excel application scope (in your case you have image exists activity inside excel scope, which will open excel immediate and goes to image exists activity before excel is open completely),

what you can do is try to
set your TIMEOUT property for 10seconds (10000) and see

3

@Vishal_K

Thank you for a quick reply! How do I set the Timeout?

4

Hi @amrit.karwal

Go to property of the Activity
image

5

@Vishal_K
Thanks. I only have the Timeout option within Properties for the image exists function and not the Open Excel file function. I added it to the image exists and the pop up box appeared first :frowning:

6

@amrit.karwal have you try system book activities?, this activities dont need excel, so you wont have any pop up

image

1 Like
7

Hi @amrit.karwal,

It works fine for me with the below steps

image
image526×647 28.5 KB

and Image exist properties should be
image

Please let me know if any issues still exist. If yes let me know the what pop up you get when you open Excel.

I hope this helped you to find the solution. If yes please mark this as a solution

Thanks,
Arun Vignesh S
We only have what we give

8

Hi @arun_vignesh

image

This is my image, this is where I’ve added the timeout
image

And this is the pop up

image
image970×313 43.7 KB

This message pops up before excel has opened and therefore my sequence doesn’t work

9

Hi @amrit.karwal,

There are two options

  1. Add a click to click on the “update” option in the error message box
  2. You can suppress the message box by following the below step
    I'm getting this error - this workbook contains links to one or more external sources that could be unsafe
    (step 2 is personally your risk. It is a third party answer)

Thanks,
Arun Vignesh S