run .bat file to remove the .bak file - run after each output..since i have multiple outpu

[Raj_007]

Hi All,

I have this scenario where i write the output to the excel using the overwrite sheet or range by specifying the range for the sheet.

I have used the block until done tool to wait until the output file is written then go to the 2nd output file with the same overwrite sheet or range.. I have around 10 sheets that i write into the same file but in a different sheet

what is the issue? sometimes i get this error even though i used the block until done - error - cannot create the .bak file

went through the forum and found out that there are few options to get over this

1). Using the event delete the .bak file - but this only works if you are creating one sheet which has a .bak

2). My scenario is to delete the .bak file after each sheet 

3). If I have to run the .bat file with DELETE with the specified location of the batch file - how do i use this after each output of the sheet is written

any suggestions/guidance - thanks a lot for your time

[chuckleswk]

If you're able to, I would recommend that you get away from the Block Until Done tool and use a Control Container around each output. You can then link your containers together that the follow-on file won't write until the previous one is completed. This will ensure that the file is closed and it can start the next step. I am doing this in a flow in which I am writing out to multiple tabs on multiple different sheets. At the end of the job, I am using the Run Command to delete any *.bak files that are created in order to keep the folder clean.