Parallel streams writing to same Excel book - "The process cannot access the file"

[harmarkar]

Hi all,

I'm developing a workflow using a batch macro with two outputs. The two outputs undergo some further manipulation and then get written to different sheets in the same Excel workbook. I'm getting an error that one of the parallel processes cannot access the file as it is being used by another process. Is there a way to use the Block Until Done function when the two paths of the workflow do not originate from the same place? Or is there another workaround I can use?

Example image below:

[Mathias_Nielsen · Accepted solution]

Hi @harmarkar, 

Try using the newly introduced Control containers. Just make sure you connect the containers together like in the photo. Then it will run one output tool and then the next.

Hope this solved it :)

[harmarkar]

Thank you Mathias, this is exactly what I was looking for!