Excel 2003 Automation using C#
Posted on 2009-05-04
Background: I developed an application that automated Excel 2003 using C#.Net in VS 2005. The development machine had Excel 2003 loaded on it. The application built, deployed, installed and ran just fine on the user's machine.
Change: Excel 2007 was added to the development machine, without deleting Excel 2003, so both 2007 and 2003 are on the machine. No change was made to the application.
Problem: When the application is redeployed and installed on the user's machine it comes back with an error saying that Office (or Excel) Object library 12.0 is not installed on the his machine. [I don't recall the exact error since this happened a few months ago, and I'm just now getting back to it.]
So I don't get it, the application compiled with the Excel 2007 object library even though the aaplication sets a references to Excel (and Office) 2003.
Thanks for you comments in advance.