I m using Excel sheet for retrieving data to the script.
This is for creating a user in a web page.
I have used 10 rows first time, if I run the script for the second time I need to take from 11th row in excel sheet.
[ QUOTE ]
How can I Process the record only when the value is "No".
please give me the code
[/ QUOTE ]
You need to check the value in the if block. Something like this (pseudocode):
<font class="small">Code:</font><hr /><pre>count=varsheet.usedrange.rows.count
for i= 1 to count
if <cellValue> equals "No"
actions which you need to perform
In this case, use code like this:
<font class="small">Code:</font><hr /><pre>For i = 1 To cnt
If var2.UsedRange.Cells(i, <put the correct column index here>.Text = "No" Then
' perform the needed actions with your application
This code will perform the actions you need to perform only if the value in the specified column is 'No'.