Excel.Workbook.Open in VB.NET for automation

S

Sachin Patil

Hi All,

I have excel automation code which works perfect on excel
2002 and excel 2003 versions. But when I deploy this same
code on machine with excel 2000, It gives me error at
opening a extsing workbook on the disk. The error goes
like :-

System.NullReferenceException: Object reference not set
to an instance of an object.
at Excel.Workbooks.Open(String Filename, Object
UpdateLinks, Object ReadOnly, Object Format, Object
Password, Object WriteResPassword, Object
IgnoreReadOnlyRecommended, Object Origin, Object
Delimiter, Object Editable, Object Notify, Object
Converter, Object AddToMru, Object Local, Object
CorruptLoad)

My code opens ObjExcel.Workbooks.Open("c:\temp\abc.xls")
Can anyone help what to do to make this work on excel
2000 machine?

thanks,
Sachin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top