Automation Developer Associate Training

[Sediqullah_KismatKhan]

I was doing the exercise creeating excel file and then copying the data from other excel files. But it doesnt close the excel file which makes it impossible to run and its that the file is opened. I also tried to use the kill process activity but then it throws an RPC server unavailable error.

[pradeep931 (Pradeep Bandharam)]

@Sediqullah_KismatKhan

RPC server unavailable error.

Hi @Sediqullah_KismatKhan

Please refer below thread

Excel Crash Error The RPC Server Is Unavailable Exception From HRESULT 0x800706BA

What troubleshooting steps need to be taken in order to resolve the issue "The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)" in Excel? Description: If an Excel crashes with error message "The RPC server is unavailable" and the HRESULT code 0x800706BA while working with UiPath and Excel. Root Cause: One of the possible causes of this error is when output is taken from a variable from the Excel Application Scope, and then the Excel instance is closed (in any way available, …

[Sediqullah_KismatKhan]

It removes the error of (RPC server is unavailable) when i remove the kill process activities but then it gives me the error that the excel file is open. The scenario is such that I open the file make changes then it should close and then open and add the data from other excel file.