developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 4 and 5 Forum Notes/Domino 4 and 5 Forum

Hi All,

I have a problem importing Excel files...

I am giving a condition, if either of the first 3 columns in Excel file is not equal to null, then import the file, otherwise exit...

My Condition:

If .Cells( row, 1 ).Value <> "" Or .Cells(row, 2).Value <> "" Or .Cells(row, 3).Value <> "" Then
.....Import Excel file
Else
......Exit

But this condition is checking for the first 2 conditions and not checking the third condition, though its true....

What could be the problem... Can anyone gimme some suggestions..

Thanks
Suresh

Go back