Office 2013- Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Question

We have upgraded our PCs from Win 7 32 bit 64bit. After that some of our tools which are 32 bit based not working which are using microsoft.office.excel.interop.dll.  ( fetch data from excel)

Windows Version : Window 7 Enterprise

Office Version : Office 2013 

Visual Studio version 2012

But it is working in Windows 8 / Office 2013 / Visual Studio 2012 environment

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

How to resolve it ?

Any known inssue ?

Answer 1

Hi friend,

Welcome to the MSDN forum.

Refer to your description, your issue is about the excel development. Since our forum is to discuss the VS IDE, I will help you move this thread to the appropriate forum for a better support, thank you for your understanding.

Best regards,

Sara

---

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 2

See if the below link helps with your issue:

https://blogs.msdn.microsoft.com/dau-blog/2012/04/20/how-to-solve-unable-to-cast-com-object-of-type-microsoft-office-interop-excel-applicationclass-to-interface-type-microsoft-office-interop-excel-_application/

Mismatched versions of Interop assemblies can cause problems. Sometimes it's better to just use late binding (e.g. CreateObject) for automation.

---

Paul ~~~~ Microsoft MVP (Visual Basic)