Solved - Error in using Office/ Excel Components in Pega Robotics
we have seen errors in using MS-OFFICE components like EXCEL, WORD, OUTLOOK in Pega Robotics Automation
our environment is Windows 10 and MS-Office 2016.
if drag Excel component (after adding reference Microsoft.Office.Interop.Excel ) onto to Global Container and set any property , for example, set 'Workbook' property , then immediately it throws below error
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
we resolved this by doing Registry Edit, details are documented and attached for reference
***Moderator Edit-Vidyaranjan: Tagged Community Shared Knowledge***
Cigna Corporation
IN
Hi ShivaRam,
We are facing similar issue as above but couldn't resolve. Please find the issue we are facing in the post for below error .
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook._MailItem'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00063034-0000-0000-C000-000000000046}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).
In Registry Editor, we are unable to find Win32 or Win64 on searching with 63034 for error IID {00063034-0000-0000-C000-000000000046}
In our case: Interface>IID >TypeLib.
In your case: TypeLib>IID > Version(8.7 or 9.5) > 0 > Win32 .
Could you please help on this.Thanks in advance.
Pegasystems Inc.
US
Hi @AngelD07,
Yes. This post is a Knowledge Share post so it has the resolution within the original post. It looks like they also attached a document with information. Hope that helps!
Pegasystems Inc.
US
The issue described in your SR is a different exception than the one shown in this Post. "Retrieving the COM class factory for component with CLSID {XXXXXXXX} failed due to the following error: 800702e4. The requested operation requires elevation."
Pegasystems Inc.
US
In SR-C86996, the issue was that the environment was set to start Outlook as an administrator. After unchecking "Run this program as an Administrator" in the compatibility tab of the program properties, they were able to proceed.
Ford Motor Company Ltd
IN
GetWorkingInstance() could not get instance from TypeProxy. InstanceName: _ApplicationProxy1
iam receiving this error in excel .is they any solution and anything faced it