Saving different Excel formats in same file

I wish to combine three Excel inputs in different formats into the same file, each input on its own sheet.

Often during the second or third export I will run into the error that the Excel file is still in use by another process, even though the process execution from the first file seems to have finished.

I tried to use the "Block Until Done" tool, but it seems to only work when you have your data combined into one table.

i also havent found any solution from the other posts in the forum.

Can anybody help me?

I am using the CReW Wildcard XLSX macro, not sure if that might be the reason?

Thanks!

Workflow

Accepted answers

JReid

There's a CReW macro called parallel block until done that I use for this all the time. Here's a video explanation

The macro can be downloaded in the pack here

All comments

Jonathan-Sherman

Hi @honshu,

You could use a union after your formula tools to bring all records together, followed by a block until done. Use a filter tool after each anchor of the block until done to only keep the set of records you want to output from that anchor and use an output tool on each?