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