TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
maayah2000
NA
11
0
code error, can any one tell me where is the error
Dec 7 2004 12:32 PM
hi pleaze i wrote this code in vb, i want open excel sheet get some data from at run timel there is an error in line oBook.OpenLinks("c:/test2.xls",System.Reflection.Missing.Value,System.Reflection.Missing.Value) the error is "object reference not set to an instance of an object" then, please look to the line string1 = oSheet.Range("A1").Value string2 = oSheet.Range("B1").Value its true or not please tell me what can i do? how can i take data from an excel sheet CODE 'strings to put data from excel sheet Dim string1 As String Dim string2 As String 'open workbook in Excel Dim oExcel As Excel.Application Dim oBook As Excel.Workbook oExcel = New Excel.Application oExcel.Visible = True oExcel.UserControl = True Dim oBooks As Object = oExcel.Workbooks Dim ci As System.Globalization.CultureInfo = New System.Globalization.CultureInfo("en-US") oBooks.GetType().InvokeMember("Add", Reflection.BindingFlags.InvokeMethod, Nothing, oBooks, Nothing, ci) oBook.OpenLinks("c:/test2.xls", System.Reflection.Missing.Value, System.Reflection.Missing.Value) oBook.Activate() 'Get the first worksheet in the workbook so that you can 'make changes to it Dim oSheet As Excel.Worksheet oSheet = oBook.Worksheets(1) string1 = oSheet.Range("A1").Value string2 = oSheet.Range("B1").Value oBook.Save() oBook.Close() oExcel.Quit()
Reply
Answers (
1
)
n tier development
How to get actual integer input from Console?