Apologies if this is in the wrong place and needs to be moved.
I've built a small application which takes in Excel data, manipulates it and creates a workbook with charts. The PC I first built it on has Excel 2003, 2007 and 2010 installed and I referenced the Microsoft.Office.Interop.Excel (version 11.0) dll. When I
transferred to a client's PC which had only Excel 2003, I got a compile error and had to redo the reference to Excel. When I transferred again to another of the client's PCs which had only Excel 2007 installed, it again threw a compile error and I had to reference
the version 12.0 Excel object library. Naturally, going back, this version didn't work on the PC with only Excel 2003 installed.
Is there a way round this, other than to build separate versions of the application for each version of Excel? Thanks in advance for any help.
View Complete Post