Excel - COMException:The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

Hello All,

I have this COMException while trying to execute a macro via robot. The previous Q&A didn’t seem to provide clear insights. Any ideas how to solve this problem ?

Appreciate your inputs
Hara

@Hara_Gopal

Is Excel Application installed in that Robot machine ?

Can you please tell more details about the issue for better understanding. So that we can check and help you.

Give a first check on:

  • excel is properly installed / available

@ppr, @lakshman, Yes excel is installed properly, macros enabled etc. The target file on which the macro needs to be executed in saved he SharePoint. The only error i see is as shown below:

“Execute Macro: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)”

The other possible reason: Every month our servers are updated with new patches, sometimes this could cause problems.

I am however not sure what is causing this problem, previousy the bot ran well

Thanks
Hara

thats a good hint

Maybe a general internet research can bring out some more ideas
https://social.msdn.microsoft.com/Forums/vstudio/en-US/08f13e9d-895c-4102-b6d9-e327af8cf8c0/0x80029c4a-typeecantloadlibrary?forum=vsto

Have finally found the reason for this error. This is because of problem with data and doesn’t seem to be a technical issue. The data in the target Excel Sheet has formulae that resulted in errors (the typical excel error #N/A). For anyone who may come looking for the answer, check the source file and see if there are any data inconsistencies/excel formulae error. Fix them, you may have then solved the problem …

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.