Closing userform with robot

Help StudioX
, , , ,
1

I am using an excel file with a userform. Normally, this userform is designed to be visible when excel is opened. That’s why the robot hangs because it is opened with the excel userform that opens when the robot is first run. Is there a way to close the userform after opening excel with robot in excel? I tried making the file extension .xlsx with copy file and closing it with the Alt+F4 keyboard shortcut, but it didn’t work.

2

Hi,

Can you try the following?

First, turn on ShowDeveloper at Filter of Activities panel
Next, put Parallel activity.
Then put UseApplication/Browser and click which indicates to close button of the userform, in left side lane
and put UseExcel in right side lane.

img20220425-3
img20220425-31297×660 46 KB

Regards,

3

well I tried but it didn’t work. Robot opens Excel then do nothing.