How to run two macro simaltaneously?

Help Studio
, ,
1

I want to open two macro enabled excel at same time and run the macro in both excel at same time to reduce processing time. How can i achieve that

2

@chandresh_agarwal,

Try using Parallel activity.

Thanks,
Ashok :slight_smile:

3

I tried but getting attached error on running.

image
image1910×1027 83.9 KB

4

Hi,

Do you try to open same workbook from 2 excel processes? Probably it’s impossible even though we open them manually.

Regards,

5

These are two different excels

6

These are two different excels i am trying to open and not the same

7

Hi,

All right. Can you try as the following?

Write 2 workflow file for running each excel macro and set AlwaysCreateNew at Process mode in ExcelProcessScope.

image

Use Parallel activity and put 2 InvokeworkflowFile activities with Isolate option.

image
image1229×501 35.6 KB

Regards,

8

I tried…if my macro is running on one file, it is giving attached errors for 2nd file.

image
image1739×665 43.6 KB

9

Hi,

Do the 2 macros work simultaneously in manual (without UiPath)?

Regards,

10

Yes two macros run simaltaneously without UiPath

11

Hi,

In my environment, simple 2 macors work simultaneously by the above way.
Can you try the following?

  • Put kill process activity with “excel” just before Parallel

image
image838×399 14 KB

  • Set “Reuse if exists” at Process mode property in ExcelProcessScope.

Regards,