I've developed a VB.NET application which opens an Excel spreadsheet.
I've referenced the Excel Interop Assembly version 11.0 (Excel 2003) on
my machine. Then I tried to deploy this application, with the Interop
DLLs, on a client's machine who has Excel 2000.
It crashed when the program tried to open the spreadsheet with a
protected memory violation error.
I assume this is because my client's machine doesn't have the same
version of Excel that I do. But my question is, how does Microsoft
expect us developers to code for compatibility? Are we supposed to use
the Interop assemblies for the earlier Excel version and not the later
one? If so, what do we do if we don't have the earlier version
installed on our development machine?
I need HELP on this ASAP so I can get paid for delivering this!
Damon