I am unable to delete an excel file via executing multiple transaction item since i am reading the values from excel to send an email. I am getting an error as “File is being useds by another process”.
Can someone suggest the best way to deal with this?
If you are using excel application scope, please use close workbook activity to close the instance gracefully. You may have to create a variable of the workbook instance and pass the same to the close workbook activity.
Please note the close workbook activity should be called outside the excel application scope.
Also add in a small delay between close and delete activity.