Excel 2000 vs 2002
-
Hi. I got a problem getting a program i wrote in VB.net to work with excel 2000. It works well with excel 2002. The error occures within this code: ExcelApp = New Excel.Application() ExcelBook = ExcelApp.Workbooks.Open(ExcelFile, False, True) ExcelSheet = ExcelApp.ActiveSheet This is the error i get: "Object reference not set to an instance of an object. interop.excel at Excel.Workbooks.open(String Filename, object Updatelinks .......all the optional attributes.......) " Odd Magne Vea
-
Hi. I got a problem getting a program i wrote in VB.net to work with excel 2000. It works well with excel 2002. The error occures within this code: ExcelApp = New Excel.Application() ExcelBook = ExcelApp.Workbooks.Open(ExcelFile, False, True) ExcelSheet = ExcelApp.ActiveSheet This is the error i get: "Object reference not set to an instance of an object. interop.excel at Excel.Workbooks.open(String Filename, object Updatelinks .......all the optional attributes.......) " Odd Magne Vea
Have you tried to re-import the libraries you are using? Because interop DLLs probably need to be regenerated to work with another file version... greetz ;-) *Niels Penneman*
Software/Dev Site
Personal Site