I have one process that is using 2 append range activities to different sheets at the same time under one excel application scope.
here is an example -
For some reason, the data is not saving to an excel file sometimes. I tried using visible, adding delay in between. None working so far. it saved to sheet1 without a problem, only having problems saving into sheet2 (it’s not working all the time.) any idea to solve it ? Or should i use each excel application scope for each append activity…