[RESOLVED] VB and Excel

[Xenobius]

Hi all again, I would like to make a small program so that I learn while doing it.

I would like to input a lot of number and information in an excel sheet, and than I would like to access the data (read) from the excel sheet from VB and use it for sums.

In other words, the excel sheet is to be filled manually. VB has to read it only. nothing should show onscreen apart from the form of the VB.

I don't have the slightest idea of what to declare, how to communicate and how to read data from a specific cell.

thanks all

[The_Duck]

Take a look at Office Automation

[Xenobius]

no luck... anyone else please?

thanks btw

[Xenobius]

Hello all. I have resolved this by the following code!

Dim xlapp As Excel.Application
Dim xlbook As Excel.Workbook
Dim obooks As Excel.Workbooks
Dim xlsheet As Excel.Worksheet
 
xlapp = New Excel.Application
obooks = xlapp.Application.Workbooks
xlbook = obooks.Open(Application.StartupPath & "\test.xls")
xlapp.Visible = True 'You can remove this line if you do not want to show the excel sheet 
 
xlsheet = xlbook.ActiveSheet
 
MessageBox.Show(xlsheet.Cells(1, 1).value) 'were [B]1,1[/B] is [B]x,y[/B] in the excel sheet

thanks all

PS. You have to add a referance

you can see it in the picture attached