Hi,
You are getting this error because you are using i in place of sheetid. Since i is changing with every iteration, code is trying to fetch value from a column, in sheet i. You can omit using i and just give only the column name. The best way to do this is:
You are getting this error because you are using i in place of sheetid. Since i is changing with every iteration, code is trying to fetch value from a column, in sheet i. You can omit using i and just give only the column name. The best way to do this is:
Code:
CntDtData=DataTable.GetRowCount
For i=1 to CntDtData
DataTable.SetCurrentRow(i)
Username1=DataTable.Value("Username")
Password1=DataTable("Password")
........
........
.....
Next