For Each Excel Row: COM object that has been separated from its underlying RCW cannot be used

[MartinJA (Martin Juel Andersen)]

Hi out there.

I am having trouble with a part of my automation.

I need to check if a number exists in an excel sheet.

It look like this:

It keeps throwing an error, I have tried with delays and kill EXCEL.EXE but that did not work.

Thanks in advance

[ashokkarale]

@MartinJA,

Refer this thread.

Excel Activity -- COM

Hi When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this Use workbook activities instead of excel application scope and other excel activities Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Ex…

COM object has been separated from its underlying RCW cannot be used?

In modern view i am using clear sheet under excel application scope before write data table to excel. i am getting this error. how to fix this please.

Thanks,
Ashok