Awesome
That’s actually a good approach where usually we send mail to the user that the process completed or not
But with excel is fine as well
So coming to the point
Put the whole sequence in the TRY Block of TRY CATCH activity
Where in the very beginning of the TRY block mention a assign activity like this bool_error = False
And then place the set of activities in the TRY Block
And if any exception occurs it will go to CATCH Block and there as a first activity we can mention as bool_error = True
That is if error occur it will assign the Boolean variable as false
Then in FINAL block of try catch activity
Use a IF condition like this
** Not bool_error = True**
Now if this condition is false means no error and goes to THEN apart where place the excel application scope and insert the value as success or it goes to ELSE part where update as unsuccessful
Fine click that exception so that we will get to know the exception type
Based on that we can include that exception as well in catch and the same set of activities to update the excel