Hi Janris,
In your question given above you have just asked for 3 columns A,B,C. So I took that example code
You can use the below statements to the above code.
Row_Count=xl.ActiveSheet.UsedRange.Rows.Count
In your question given above you have just asked for 3 columns A,B,C. So I took that example code
You can use the below statements to the above code.
Row_Count=xl.ActiveSheet.UsedRange.Rows.Count
Code:
For i=1 to Row_Count
UserId=xl.Cells(i,1).value
FirstName =xl.Cells(i,2).value
LastName=xl.Cells(i,3).value
Browser("...").Page("...").WebEdit("UserId").Set UserId
Browser("...").Page("...").WebEdit("FirstName ").Set FirstName
Browser("...").Page("...").WebEdit("LastName").Set LastName Next
xl.ActiveWorkBook.Save
xl.Application.Quit
Set xl=nothing