Answer Posted / rajani_kanth

Option explicit
Dim objExcel,objExcelSheet,row,col,i,j

Set objExcel=CreateObject("Excel.Application")
objExcel.Workbooks.Open("D:QTPdata.xlsx")
'objExcel.Application.Visible=true
Set objExcelSheet=objExcel.ActiveWorkbook.Worksheets("Sheet1")


row=objExcelSheet.UsedRange.Rows.count
col=objExcelSheet.UsedRange.Columns.count


For i= 2 to row
For j= 1 to Col
' Print objExcelSheet.cells(i,j).value

InvokeApplication"C:Program Files (x86)HPQuickTest Professionalsamplesflightappflight4a.exe"
wait 1
dialog("Login").WinEdit( "Agent Name:").Set objExcelSheet.cells(i,j).value
wait 1
J=J+1
dialog("Login").WinEdit("Password:").Set objExcelSheet.cells(i,j).value
WAIT 1

DIALOG("Login").WinButton("OK").Click
wait 1
window("Flight Reservation").Close
wait 1

Next

Next


objExcel.Workbooks.Close
objExcel.Quit
Set objExcelSheet=Nothing

Set objExcel=Nothing

How will you format a number in percetage format in vbscript?

997

---

Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.

2042

---

Explain about tristate constants?

1023

---

Mention what is byref and byval parameters in vbscript?

1012

---

Mention how to create a cookie using vbscript?

1007

---

What is the purpose of folders object of scripting.filesystemobject class in vbscript?

1370

---

Which in-built function is used to format the number in the vbscript language?

1015

---

Explain the tristate constants in vbscript?

1036

---

How to open browser in vb script?

1242

---

How will you get the octal value of the given number in vbscript?

957

---

Hai this is sheik, i want to learn VB scripts for web application pls guide me what are all basic things need to know to learn VB scripts in web application.

2071

---

How you can call vbscript functions?

1089

---

How do you declare a variable in vbscript?

1062

---

How to declare an array in vbscript?

1326

---

Explain about the extension .hta?

1075

---