hi i m runing a login script using multiple data by importing from excel sheet

hi i m runing a login script using multiple data by importing
from excel sheet, now i want to get a status pass or fail each
time the script run for multiple data??
so anyone can help me out?

Question Posted / tapas.swain

3 Answers
4983 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi i m runing a login script using multiple data by importing from excel sheet, now i want to get ..

Answer / meher dawlekar

Hi...
Answer for your question :
Ex : Flight Reservation Login with multiple data from the
excel sheet
Here i am taking the Excel sheet(meher.xls) having two
columns name 1.agentname
2.password,with multiple set of values in its respective rows
****************Script*****************************

option explicit
dim aname,pwd,sheetcount

datatable.addsheet"input"
datatable.importsheet"path of the source sheet with
sheetname with its extension.xls","meher","input"

sheetcount=datatable.getsheet("input").getRowcount

aname=datatable.value("agentname","input")
pwd=datatable.value("password","input")

For i= 1 to sheetcount step 1
Dialog("Login").winEdit("Agent Name:").set aname
Dialog("Login").winEdit("Password:").set pwd
Dialog("Login").winButton("OK").click

If Window("Flight Reservation").Exists Then

msgbox "Your Login status is Passed"

else
msgbox"Your Login status is Failed"

Endif

***********Hope you are cleared with my answer**********