I want my output to be filter in differents categories and output to the same excel sheet but a tab by categorie. (see attach) It is possible? For the moment i have errors the file is already open when others output wants to write their datas.
thanks
Solved! Go to Solution.
Hi David,
Check out the "block until done" tool in the developer tab - you could place several after your central select tool. This blocks output to the second branch until the first has completely finished running, allowing the excel file to finish being written to before you try to write to it again for a different tab.
Alternatively, if you have the CREW macros installed, you could use the parallel block until done tool, which is similar.
Hugo