I have been long wondering how can I solve this problem. I have this excel file with multiple sheets that I loop into. At the start of the process, I would get the Workbook App var to get all the sheets. Add a for each loop for all the sheets, then process it. Inside the said process, I need to open an another excel file for copying of the templates and to put the append details. At the end of the loop, I put an close workbook activity.
My problem is, I sometime, before I open the another excel file for template. I get an error of
HRESULT: 0x80010108 Which can be solve( I think) by killing the Excel process. I did this before but it would also kill the background process of reading each sheet, that would give me an error for
For each Sheet in WBMainFile: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
Which I think occurs since it can’t get the other sheet from the excel file, as it has been closed my kill excel.
This works sometimes, but I don’t really get what’s causing these problems. I hope you can help me, thank you.