I'm writing an Excel Addin that should work in both 2007 and 2010. When I create a new project with Visual Studio I need to decide which version I want. I've chosen 2007 before, but since I have 2010 installed I can't debug it. I get an error:
You cannot debug or run this project, because the required version of the Microsft Office application is not installed.
It is my understanding that if I target 2007 I should be able to run it on both 2007 and 2010. Is that correct? If that's so, can I debug it using 2010?
You can go ahead by creating the addin for excel 2010. While you build the project you will get a patch file along with the add in. Users can install the patch before installing the add in on systems using excel 2007.
here: http://metasharp.net/index.php?title=Csharp_and_Excel_Interoperability