Hello everyone,
I've been trying to figure this out myself, but have just run into an issue I can't resolve with searching and examples. I'm trying to open an excel file to read from it, and I've figured out how to open a NEW excel file. I can't, however, seem to figure out how to open an excel file that already exists.
Here is what I have so far:
Code:Dim objApp As Excel.Application Dim objBook As Excel._Workbook Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim objBooks As Excel.Workbooks Dim objSheets As Excel.Sheets Dim objSheet As Excel._Worksheet Dim range As Excel.Range ' Create a new instance of Excel and start a new workbook. objApp = New Excel.Application() objBooks = objApp.Workbooks objBook = objBooks.Add objSheets = objBook.Worksheets objSheet = objSheets(1) objApp.Visible = True End Sub




Reply With Quote