I'm trying to copy Sheet from Excel File and paste it in same Excel file with New Sheet Name, i'm getting error :The process cannot access the file, because it is being used by another process

Hi, I’m trying to Copy Sheet from Excel file and paste it with “Sheet Name”.
Read Range : Sheet2, dt_sheet2
Write Range: dt_sheet2, “Daily report”(New Sheet Name).
I’m getting error:
The process cannot access the file, because it is being used by another process.
Tried :Kill ProcessActivity,
Copy Sheet Activity, still same result.
Any help please?

HI ,

Usually the kill process itself works but some might be in not responding . Check in task manager and close all the excel process and retry .
And while trying kill process, get the list of process and if more than one excel , close them too.

I tried it but still same issue.

If the file is in share path, the local can be taken for processing.
Does this error occurs while trying manually .

file is in local computer, i can do it manually, i even tried restart system, still same issue

Are you using Excel Application Scope? Don’t. Use the workbook Read Range and Write Range activities.