BUG: “Old format or invalid type library” error when automating Excel (Christin Boyd)

re: BUG: “Old format or invalid type library” error when automating Excel (Christin Boyd)

Fabz — Tue, 08 Dec 2009 14:09:40 GMT

> And third, these problems do not occur if you use VSTO 2005 SE, VSTO 3.0 (which ships with Visual Studio 2008), or Visual Studio 2010.

Sorry, but this cannot be true. I am using Visual Studio 2008 Professional Edition with SP1, .NET Framework 3.5 with SP1 and Excel 2007 and exactly this same error occurs. You will certainly believe me it took me a real pain in the neck to figure this out... .

re: BUG: “Old format or invalid type library” error when automating Excel (Christin Boyd)

Fabz — Tue, 08 Dec 2009 15:24:39 GMT

Sorry, I might be wrong with my statement: The problem certainly is there in Office 2007, but since I am developing an Automation AddIn using a Visual Studio "Library Project" (instead of using Visual Studio Excel AddIn Project) I cannot say for sure if the bug's still there or not.

However, when developing a Windows Form Application as suggested in MS's "steps to reproduce the behaviour" the bug occurs also.