If For Each Activity contain a Excel Application Scope Activity? It maybe occur a Exception!

Help Studio
1

Hi guys
When a For Each Activity contain a Excel Application Scope Acitivty,It maybe occur a Exception!
The exception key words likes below.
“System.Runtime.InteropServices.ComTypes.IConnectionPointContainer”
“{B196B284-BAB4-101A-B69C-00AA00341D07}”
HRESULT:0x80010114
but If I add a Delay Activity to delay 3secs ,It can running normal.
It’s may occur on few computer,not all.
Can any knows the reason? or How to avoid It, except add a Delay Activity.
Best Regards!

2

Hi,

It’s probably because you try to launch (next) excel.exe although you haven’t completed process for closing excel.exe yet.

Another workaround might be to keep open excel.exe.For example, if we open an excel file (whatever will be good) before For Each and set variable to Workbook property of Excel Application Scope activity, excel.exe will be kept opened until Close Workbook activity after For Each.

Regards,

1 Like
3

Hi @Yoichi
Yes,It is.
But I think It’s need uipath to reslove this problem,in For Each Activity,one line finished, anther one started.I found this problem a few hours. :joy: