Use Excel File: COM object that has been separated from its underlying RCW cannot be used

Help Studio
, ,
6

In my case, I was using ExcelProcess scope/Use Excel file/ for each excel row then invoking a Workflow that opened an use excel file with a Single Scope Application.

Solution was to change Single Scope Application → Excel Process Scope and setting the property “Process Mode” to “Always create new”.

Explanation: Second excel file was opened reusing same thead, so, when going out of the Incoke and trying to use the For each excel row loop variable, it was not present anymore.

3 Likes