Error Outputting multiple files using Batch Macro

[GayatriPanigrahi]

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. 

[GayatriPanigrahi]

@Qiu Instead of entire path i am using option of Change File/Table Name. Because i need to overwrite sheets.

[atcodedog05]

Hi @GayatriPanigrahi 

Now i got a better as expected your schema will be different.

Use this at beginning in the macro to give gap between runs.

https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

Ideally, you should not be facing this issue. You can also drop a mail to support@alteryx.com and ask them to check on this issue.

Hope this helps : )