Automation versions
maybe Ive just confused myself over looking something obvious
trying to write out a grid to excel
followed one of the many examples of how Im to do this
added my reference in my case excel 11 object library
and it works like a charm
that is until my program is run on a machine with excel 2000 rather then of 2003
then it fails
I could also add excel 5 object library rather then the excel 11 object library but then non of my code works anymore
Dont really need to access fancy excel features just to add some texts in some cells
Thanks for any pointers you experts would be able to supply
[656 byte] By [
Rudegar] at [2007-11-19 14:04:08]
# 1 Re: Automation versions
Latest COM components should have backward compatibility (COM fundamental, interfaces can not be changed once the component is released). So, if your user using excel starting from Excel 2000 versions then find the Excel9.olb file in Excel 2000 installed machine (Excel8.olb for Excel 97) and generate interop assemblies out of it. Then reference the newly generated interop assemblies in your project. If your C# class is already developed using latest Excel interops, you might get some compiler error (ex: in workbook.open and save, latest versions take couple of extra parameters). Fix the compiler errors and your are set. But, you will lose the new functionalities declared in latest COM components.
