Excel Visual Studio Design Time Adapter Add-in Error

Question

Hi..

I am trying to open excel workbook 2003 using VSTO. but i am getting error again again like

" Project cannot be created because the application add-in is not working correctly and might have been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or About Microsoft Office Excel, and then click Disabled Items. If either "Word Visual Studio Design Time Adapter Add-in" or "Excel Visual Studio Design Time Adapter Add-in" appears, select it and click Enable. If not, reinstall or repair your installation of Visual Studio Tools for Office."

Can somebody help ??

Answer 1

Maybe this is the same problem I was having with Design Time Adapter errors using VSTO:

http://bishoponvsto.wordpress.com/2009/08/17/vsto-design-time-adaptor-error/

Just before repairing the install, as is advised, I had a quick check of the Task Manager, and noticed that an Excel.exe process was still running. Ended this process, and hey presto, it fixed the problem.

It appears that sometimes when debugging/running your project, if it fails or stops before the Excel app gets closed by your code, the design time adaptor hangs. This happened to me because an Automation Excetuable had left an instance of Excel up and running in visible = false mode.