Can we use Flower Brackets while using If...Else condition?

[dinesh_d_r]

Problem:
I am reading the contents of the sheet1 based on the conditions in sheet1 i need to read the contents of the sheet2.

By using if else condition i am not able to read the contents of sheet2.

Please can any one suggest if they have any idea of reading excel sheets?

[yaron.assa]

Do you mean something like this:

Code:

If DataTable.Value("Param1", "Sheet1") = "Something" then
   MsgBox "OK"
Else
   MsgBox DataTable.Value("Param2", "Sheet2")
End If