Could not determine the dependencies of the COM reference "Microsoft.Office.Interop.Excel"

1

I'm trying to run a project I loaded which uses Microsoft.Office.Interop.Excel.
I've installed the Primary Interop Assemblies and the bootrap as well for Officer 2010 (as installed).
I had Office 2013 which I uninstalled and reinstalled Office 2010.
I've added the Microsoft.Office.Interop.Excel through the COM references tab.
Afterwards I've deleted the 1.8 excel version from the Registry as mentioned here http://social.msdn.microsoft.com/Forums/office/en-US/dd052f27-20d6-4b6b-9d8b-fe4fd9c6b9fc/broke-excel-interop-com-assembly-after-installingremoving-2013-beta-release?forum=exceldev
I've restarted the computer, and still I get the warning above and also :
Could not determine the dependencies of the COM reference "VBIDE". Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)

I've understand I should add the references using the .NET tab and not COM tab, but there is no .NET tab in the references window.

c#
.net
office-interop
asked on Stack Overflow Nov 22, 2013 by SagiLow

1 Answer

2

If you're using VS2012, you should see the Interop references under Assemblies -> Extensions:

enter image description here

The result is a .NET reference that looks like this:

enter image description here

Update: As mentioned here, ensure you have the full VSTO installed (not just the runtime):

enter image description here

answered on Stack Overflow Nov 22, 2013 by nunzabar • edited Nov 22, 2013 by nunzabar

User contributions licensed under CC BY-SA 3.0