Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Want to Iterate!!
#4
Solved: 11 Years, 3 Months, 4 Weeks ago
see the piece of code below
I have assumed each row in your excel contains details of one user
Code:
RowCnt = wb.Worksheets(sheetname).UsedRange.rows.Count

For nRow = 1 To RowCnt
    
        list_value = wb.Worksheets(sheetname).Cells(nRow,1).value
        Browser("Browser").Page("Add User").WebEdit("User Name").Set list_value
        list_value = wb.Worksheets(sheetname).Cells(nRow,2).value
        Browser("Browser").Page("Add User").WebEdit("User Name").Set list_value
Next
let me know how it goes.

Reply


Messages In This Thread
Want to Iterate!! - by wannalearn_qtp - 12-30-2009, 07:59 AM
RE: Want to Iterate!! - by Saket - 12-30-2009, 10:18 AM
RE: Want to Iterate!! - by wannalearn_qtp - 12-30-2009, 10:32 AM
RE: Want to Iterate!! - by Saket - 12-30-2009, 10:46 AM
RE: Want to Iterate!! - by UjwalaK - 12-30-2009, 03:00 PM
RE: Want to Iterate!! - by wannalearn_qtp - 12-30-2009, 05:00 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)