Error Opening Excel File in VB.NET

[Guest]

Hi, I have an application that reads in a bunch of values from an excel
application. Now this works fine on my computer but when I deploy it to a few
other computers, some of them return an 'Object Reference not set to an
instance of an object' error when I open it.

Here is my code....

Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook

ExcelApp = New Excel.Application
ExcelBook = ExcelApp.Workbooks.Open(Filename) ' error is here

I've narrowed it down to this only happening on computers with an older
version of Excel than I have currently installed. Does anyone know why this
happens and a solution that doesn't involve me installing an older version of
Excel?

Thanks,

Luc

 

[Guest]

You can build your app against a lower version of Excel and have it work
across all versions. See "Achieving Backward Compatibility with .NET
Interop: Excel as Case Study" -
http://www.devcity.net/Articles/163/1/article.aspx

--scott