I am using more that one excel applications in my automation, first excel file opened at the initial of the solution and second excel file which have VBA code (Macro) opened at the end of the solution.
Macro file has to work with first file to make some changes, but Pega consider this two files as different threads and due to this macro file unable to find first excel file because of different thread.
while running this macro manually (without Pega) its working fine, its consider only one thread, but same macro creating different thread with Pega.
according to my project architecture i have to open the 1st excel workbook at the initial of the solution and 2nd file(Macro) have to open at the end of process request so i can't run both the excel at the same time.
Excel file open and close every time will not be feasible because it will take more time to execute all this process.
request you to please provide another solution on this.