MacroFile close

Help Studio
, ,
1

Helo guys,

image
image557×134 2.58 KB

I have a macro file in which first iam importing and second exporting a csv file

I have used execute macro activity to process this

image
image803×542 19.8 KB

So Data is updating in the first activity and exporting the csv file in the second activity

Durining the second activity a popup will come

image
image217×180 1.72 KB

I want to handle this popup to finish the process

2

Hi @Gokul_Murali ,

try to use close popup activity, it may help you

3

@yedukondaluaregala

But rpa is not going to the next activity after the second macro.

When clicking Ok to the Popup manually it is going to the next activity else it will be in the same activity

4

use click activity to click on OK button, indicate popup Ok button

5

@yedukondaluaregala

image
image718×678 28.5 KB

See this popup is coming for the 2nd macro activity

So if i click manually that “ok”, then it will kill the excel (Moving to the next activity)else rpa will still wait and will not stop

The RPA will move forward only when we click ok manually

6

can you check your macro first why that pop is coming

7

Hi @Gokul_Murali

We cannot handle the popup when executing the macro. If we want to handle the popup the bot should complete the Execute macro activity and come outside to handle the popup. But in this case untill we handle the popup the execute macro is in executing state.

So my suggestion is to change the Macro code to remove the popup or show the popup for fraction of seconds. This will work and no need to handle the popup after Execute macro.

Hope you understand!!

8

@yedukondaluaregala

Its in that vb code of macro

image
image470×160 2.45 KB

9

if you are generating any pop up, you will implement micro code to close the popup itself

10

@Gokul_Murali,

Use Parallel activity with two blocks of the code like mentioned in the solution mentioned below.

  1. Put your activities to execute macro in a workflow and invoke it in the Parallel activity. Make sure you check the checkbox of Isolated property of Invoke Workflow File Activity
  2. Use logic to handle popup in Parallel activity
11

@ashokkarale

image
image1388×726 58.1 KB

it is showing an error like this.

but that pop is closing

12

@Gokul_Murali,

Use Excel Process Scope/ Excel Application Scope (Classic) inside it put your Execute Macro.

Add this whole Execute macro logic in a separate workflow

13

@ashokkarale

Instead of handling the popup i kill the excel that is y the error is coming now its handled

Thank You

1 Like
14

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