How to open a Excel with a pop up msgbox?

[JP_Chang]

As title, I have a excel file, filename extension is xlsb. This file have a Workbook_open event, and it will pop up a message box.

If I use activity-“Excel Application Scope” to open this file, it will stop running before I click the button of message box. I tried to use activity-“Click”, but it didn’t work, because last activity-“Excel Application Scope” still not finish. How should I do?

[Rahul_Unnikrishnan]

@JP_Chang it would be better if you can share the scrrenshot of the popup and the error which you are getting.

[jack.chan]

you can download this snippet

Handle Pop-ups - RPA Component | UiPath Marketplace

put main flow here e.g. excel application scope

then open this workflow

edit selector and select button to close popup

[JP_Chang]

The Excel file(File Link) has a simple event(for test), It will pop up a msgbox after file opened.

In process, when the file is opened by activity, the UiPath will stop on flow-“Open test file”, and can not process to next activity-“Click button on Msgbox”.

[Manish540 (Manish Shettigar)]

@JP_Chang Can you send a sample .xlsb file which opens this type of pop-up?

[Palaniyappan (Forum Leader)]

Fine

Use START PROCESS activity and pass the filepath of the file as input under property FileName

This will open the pop up and then try using CLICK activity

Start Process

Cheers @JP_Chang

[JP_Chang]

@Palaniyappan , thank you, it’s worked. But I need to use activity-“Read Range”, and it must be under activity-“Excel Application Scope”.

While I can click the button by use activity-“Start Process”, but It will be cause another problem.

[jack.chan]

Handle popups such as Update Links - Snippet.zip (4.4 KB)

you can use excel application scope + read range with this…

handle popup in this sequence

[jack.chan]

example:
(unzip this in your project folder and run "Read range with popup.xaml"
Read range with popup.zip (4.6 KB)

[JP_Chang]

@jack.chan It’s awesome! Thanks for your help.