Hi All, I am using attached batch macro to generate multiple output sheets in single excel file. This was working fine for couple of days but now i am facing issue as "Unable to make final write Error in use by another process", is there a way to delay each iteration ? I am using Alteryx version 2019 and can not use other addon like crew macro at present. Macro_use_sample.yxzp

Error Outputting multiple files using Batch Macro

Hi All,

I am using attached batch macro to generate multiple output sheets in single excel file.

This was working fine for couple of days but now i am facing issue as "Unable to make final write <File path> Error in use by another process", is there a way to delay each iteration ?

I am using Alteryx version 2019 and can not use other addon like crew macro at present.

Macro_use_sample.yxzp

Workflow

Macros

Transformation

Batch Macro

Accepted answers

All comments

atcodedog05

Hi @GayatriPanigrahi

It's working for me. Are you facing issues with the attached workflow too?

And I can see workflow version is 2021.4

Hope this helps : )

Qiu

@GayatriPanigrahi
The input for the batch macro is not complete. 😁

Macro_use_sample-r1.yxzp

Qiu

@GayatriPanigrahi
We can also choose not to use any macro.

Macro_use_sample-r2.yxzp

atcodedog05

Hi @Qiu

Dam I didn't notice that 😅 but batch macro will work even if it's just like below

It works because the groupby has been set at this tab. You need to use control parameter only if you cant use this option but sadly not a lot of people know this 😅