I want to copy the data from excel cell without closing it, the reason behind keeping excel open is i am going to copy multiple cell data into my ERP tool one by one.
I have used below method with storing that cell data into variable and then put that into ERP tool, but then got the error “The process cannot access the file because it is being used by another process in read range”.
Here I am assigning Excel value into variable
Here I am set the text into ERP tool
You can use Excel Application scope and their activities instead of Workbook …
Since you are using the workbook activities it will give you the error, so use the excel application scope.
If you use Workbook activities inside Excel application scope then it will give you error
as Excel Application Scope opens your File and use till it gets out of that scope
That’s why u are getting this error
Instead you should Use Read Cell of Excel Activities
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
