I was struggling with this error for a few days . It came out after I’ve upgraded my project to Visual Studio 2012.

Excel 14.0 Object Library Download
Install Microsoft Excel 15.0 Object Library 5 0 Object Library Download

Dim appOutLook As Object Dim MailOutLook As Object (and followed the other recommendations) But unfortunately that did not solve it. In a copy of the database I removed all VBA from the Forms and also removed a VBA module. After that, we still get 'MISSING: Microsoft Outlook 16.0 object library' if we switch from a 2016-user to a 2010-user. May 03, 2013 How to add Microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010. Am working on Windows 8 OS. Ms Office 2013 installed on machine. To access particular COM Component. I have Installed Microsoft Office 2010: Primary Interop Assemblies Redistributable on my machine. I'm searching for Microsoft Excel 15.0 Object Library in the reference but i can't find it. I had to search for the Outlook, and Access also. I found them but i can't find Microsoft Excel 15.0 Object Library. But i do have Excel on the laptop. I also re installed MS Office 2 times, just to make sure. How can i find it?

Unable to cast COM object of type ‘System.__ComObject’ 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)).

Use Win32::OLE::Const 'Microsoft Excel. Object Library'; I looked inside Win32::OLE::Const module and it seems that the module is looking for that library in the registry. When I printed out all entries from the registry from both 32 and 64 bit I found out that this library is available on 32bit and not available on 64bit.

It shows up while it’s the time for Excel operations:

Workaround:

It occurs because I’ve installed Office 2013 instead of Office 2010 which I was using with old version of my project. After I upgraded my Office, the project was no longer able to link Excel reference. Website of the week.

Even though I referenced new Excel library which is 15.0, it didn’t work.

Solution:

Delete the Excel reference (Microsoft.Office.Interop.Excel). Version 15.0, in my case.
Install Microsoft Excel (whichever version you had been using. Version 2010 for me)
Add the Excel reference (older one. Version 14.0, in my case)

Long story short: Never take more than one risk at the same time!

Excel 14.0 Object Library Download

-->

Install the Microsoft Office primary interop assemblies (PIAs) when you install Office.

Install Microsoft Excel 15.0 Object Library 5 0 Object Library Download

Note

Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model. Office Add-ins have a small footprint compared to VSTO Add-ins and solutions, and you can build them by using almost any web programming technology, such as HTML5, JavaScript, CSS3, and XML.

To install the PIAs when you install Office

Ensure that you have a version of the .NET Framework that is no older than 2.0.
Install Microsoft Office and make sure that the .NET Programmability Support feature is selected for the applications you want to extend (this feature is included in the default installation).
Warning Ibm employee serial numberextralasopa.
By default, PIA's are embedded in your solution when you build it so you don't have to distribute PIAs to users as a prerequisite to using your VSTO Add-in or customization.

Workaround:

Solution:

Related Posts:

Excel 14.0 Object Library Download

Install Microsoft Excel 15.0 Object Library 5 0 Object Library Download

To install the PIAs when you install Office

See also