Hi everyone,
I'm trying to open an Excel doc in my program which was
written in
VB.NET and it returns the error "Object
reference not set to an instance of an object" when I try
to use the Workbooks.Open function.
This actually works fine when I use my program on a
machine that has Excel XP installed, but when I move to a
machine with Excel 2000, I get this error.
My code looks something like this:
Dim exl as Excel.Application
Dim wrkBKs as Excel.Workbooks
Dim wrkBK as Excel.Workbook
exl = New Excel.Application()
wrkBKs = exl.Workbooks
wrkBK = wrkBKs.Open("somefile.xls")
The error occurs on the last line.
I also have similar code which does pretty much the same
thing with MS Word, and the Open function works fine on a
machine with Word 2000, and Word XP.
If anyone has any ideas, I'd love to hear them. Thanks.