Excel Problem

[mentalcow200]

Please help. I'm trying to get info from a excel spreadsheet into Visual basic.I want to find any excel files that have a certain word in a specifed cell and then get all the contents out of these files and display them on a form in vb?? Is this poss???? So far all i can manage to do is open the excel file.

[opus]

If you can open it, you can read it!
Assuming your Excel-WorkbookObject is called objExWorkBooK and the Cell in question is in Row 1 and Column 1.

if objExworkBook.Sheets("Name_of_Sheet").Cells(1,1).Value="The_Certain_word" then
'get the other cells info here
End if