I have written a program in VB.Net 2003 Standard that pulls and gives information to an Excel spreadsheet, I am running Excel 2002 (XP) on an XP Pro machine. It runs just fine this way but when I give it to a Excel 2000 machine I get Null Reference Exceptions when opening a workbook. How can I make my program work for both Excel XP and 2000?
I use MS Excel 10.0 Object Library (1.4) and all spreadsheets are saved in 97-2002 spreadsheet format. The spreadsheets do open in Excel 2k.
Andy
Also, someone told me to use the MS Excel 9.0 Object Library but I dont know if that would run Excel XP. Even if it did I dont know where to find this Object Library which is not installed on my computer.
I use MS Excel 10.0 Object Library (1.4) and all spreadsheets are saved in 97-2002 spreadsheet format. The spreadsheets do open in Excel 2k.
Andy
Also, someone told me to use the MS Excel 9.0 Object Library but I dont know if that would run Excel XP. Even if it did I dont know where to find this Object Library which is not installed on my computer.