How to solve this problem?

[Happydayyy (22035153d)]

Can anyone else can help me solve this problem? Thanks!!!

Workflow:
MU-Rep sorting (in_outrange) after confi…xaml (48.5 KB)

[soundarya_A1 (soundarya)]

Hi

Actually the work flow which you have shared, has an error which is ( refer the below Screen shot)

so make sure to use the Excel Process scope.

Thanks,
Soundarya

[ashokkarale]

@Happydayyy ,

Are you missing the extention to the file name like .xlsx ?

Thanks,
Ashok

[Happydayyy (22035153d)]

If I use the excel process scope, it will come up this questions

MU-Rep sorting (in_outrange) after confi…xaml (48.4 KB)

[Happydayyy (22035153d)]

What do You mean of that??

[soundarya_A1 (soundarya)]

Read Range: COM object that has been separated from its underlying RCW cannot be used

Hey @helpplease , Please refer below thread

Hope this post will be helpful

Thanks,
Soundarya

[Happydayyy (22035153d)]

There is still an error, can anyone help me to edit it

[soundarya_A1 (soundarya)]

Could you pls take a screenshot of an error happening on that activity?

[Happydayyy (22035153d)]

still this error

[Happydayyy (22035153d)]

Can you give me the sample of doing it?

[Kanak_Lata_Singh]

Hi @Happydayyy

Please check this link , hope it helps you to understand

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

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.

Thanks

[mkankatala (Mahesh Kankatala)]

Hi @Happydayyy

Can you give the below one in the save as file field,

Completed+"\"+AppNum.toString+"MU_Rep_robot.xlsx"

Hope it helps!!

[ashokkarale]

@Happydayyy give the file extention like filename.xlsx

[Gayathri_Mk]

in save as file property provide the extension
add this one +“.xlsx”