VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
First of all, try to run Visual Studio with the /ResetUserData command line argument. Read more about that in the Error “Unable to cast COM object…” when exporting to Microsoft Excel from Team Explorer 2008 article. Obviously you are trying to connect to a wrong Excel version. Looks like you have some extra windows registry … Read more