How to change the order of the sheets

[swapsingh2712]

Hello all,

I've a workflow which is generating a excel file contains 2 sheets

TC1 (Tab1),Output(Tab2)

Is there any way to change the order of these sheets. so that Output will come in Tab1 and TC1 in Tab2

Please help

KR

swap 

[binuacs]

@swapsingh2712 @Use the block until done tool and write the output tab first then, write the second tab

[ChrisTX]

You may also need to add a Wait a Sec CReW macro  linked to the second Block-Until-Done (BUD) output, to avoid write contention errors.

For me, the BUD worked OK when I was writing the output file to my PC.  But when I wrote the file to a network drive (slower write), I got "file in use" errors because Excel didn't shut down quickly enough after the first sheet.

Chris