Read Range: The process cannot access the file ‘****CustID_1111.xlsx’ because it is being used by another process.
*** is the path.
The excel is not open but this error is thrown. Does anyone have an idea why this is happening?
Background of what I am trying to achieve : I am trying to read some entries from an excel and I want to add these to a queue, pick the data from queue & search relevant data from a website and save corresponding data to another excel.
Hi @anon24920977
Check whether the excel file is corrupted or
Check the excel activitiy is in latest versions
Nived N
Happy Automation
Thanks for the quick response @NIVED_NAMBIAR .
Excel is latest version not sure if its corrupted for any reason though. Let me check.
1 Like
Hi @anon24920977
If u are using excel application scope, instead of that try using workbook activitiy
Hope it helps yo
Nived N
Happy Automation
Pulled the do block out of excel app scope and the step went through. Thanks again @NIVED_NAMBIAR
I didn’t understand what u said @anon24920977
Did u tried with workbook activitiy?
what do you mean workbook activity? I suppose you are referring to teh Read Range activity?
I was using Read Range under Excel Application Scope. I pulled it out of the scope and used directly. It works.
1 Like
Can u share screenshot of that workflow
I think the error would be
You had used workbook read range activitiy under excel application scope
So excel application scope is using the excel file
So that is why the error is thrown
Refer for more information
Hi Team,
I know there are many threads going on for this two activity, but my doubt isn’t still cleared.
Which one out of the two is the best activity to be used while coding ? would that be excel application scope but then cost increases in that case to install excel , but other than that which one is better to be using , coding wise? can someone please help me with this query.
Hope it helps
Nived N
system
(system)
Closed
August 16, 2020, 3:31pm
9
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.