Quote:
Originally Posted by willakawill
This is relatively easy if you already know how to use automation in your vb project. If you don't already know then you have a lot to learn to get this project to work.
You need to add excel to your list of references so that you can declare variables that refer to an excel workbook. This is quite a lengthy topic to cover here so you might consider doing a google search for 'vb excel automation'
You can also find a code sample here
this code below is all what I got
Private Sub searchbtn_Click()
Dim exelAPP As Excel.Application
Dim exelbook As Excel.Workbook
Dim exelsheet As Excel.Worksheet
Set exelAPP = New Excel.Application
Set exelbook = oXL.Workbooks.Open("d:\d.xls")
Set exelsheet = oWB.Worksheets("Sheet1")
exelsheet.Range("b3", "b34").FindNext (t1.Text) ' i suppose this will search the worksheet of the specefied word
End Sub
then what???!!! when the specefied word is found ..how can i paste the other values of the same row in the other 7 text boxes??????
i dont have any idea how to make the project going ok
Thanks to all
