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
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.