Hi guys, i would like to know how to read certain cells from an excel file in order to make a database from them, but first i have to know how to do this.
thanks in advance.

Dear ,
To open excel from vb u can use the following code

Dim xcell As String
Dim xl As Object 'To open Excel
Set xl = CreateObject("Excel.application") 'Creates an object
xcell = App.Path & "\test.xls"
xl.Application.Workbooks.Open xcell, , True
xl.Visible = True ' So you can see Excel

'this how a cell reference should be given with this you can write and read from specified cell
xl.Application.Worksheets("sheet1").Cells(6, 8).Value = "TEST"
'in the above line cells(6-is column,8-is rows)

First of all thanks a lot zrtv,

now i have this doubt, how do i close the excel file i just opened, cause i want to read a lot of them in the same dir.

where do you get to know this stuff, is there a book or a website?

thanks a lot in advance ;)

For the vb to excel help better you go to excel itself then go to
vb editor, from the vb editor you can search for the help ,

Hello,
My visual basic 6 program has 2 buttons:

1) opens Excel and opens an existing workbook

2) This second button should only read the cells of the already-open workbook. But the button's _Click() subroutine rejected my attempt to pass the open workbook object as an argument.

How do I read workbook cells in an already-open workbook, from a subroutine that did not open the workbook?

Thanks

For example, you want to read the contents A1 of Sheet1 of a workbook named MyWordbook.xls

sValue = xl.Workbooks("MyWordbook.xls").Sheets(1).Range("A1 ").Value

or

sValue = xl.Workbooks("MyWordbook.xls").Sheets(1).Cells(1,1 ).Value


All you need to understand is Excel Application has a "collection" of Workbooks and each workbook has a "collection" of Worksheets/Sheets

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

hi
for basic understanding of using excel in vb. You may refer this link
VB code to Export Text to Excel and Save. You can use this for understanding how excel can be used in the vb to open,read, save, and close

__________________
Pon Saravanan
VbKnowledgebase.com