View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc[_3_] Luc[_3_] is offline
external usenet poster
 
Posts: 24
Default Error Opening Excel File in VB.NET

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