Answer Posted / manjunathareddy

Set oExcel=CreateObject("Excel.Application")
Set oBook=oExcel.Workbooks.Open(Excelpath)
Set oSheet=oBook.Worksheets(Excelsheetnumber)
oRow=oSheet.Usedrange.Rows.Count
For i=2 to oRow
Un=oSheet.Cells(i,1).Value
Pwd=oSheet.Cells(i,2).Value
Msgbox Un
Msgbox Pwd
Next

What are the advantages of vbscript?

1140

---

what is the standards used for writing the script in QTP

2382

---

can anyone send me a vb scripts code for clicking on a link and coming back on home page again does the same for many links on a web page.

2353

---

Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?

1007

---

Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)

3727

---

how to set one column as primary key in QTP and fetch values accordingly

2361

---

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

1427

---

In the Web page we have a table link, if we click on that link all the contents under that link will be sorted (asscending/Descending). Now i want to check in which order the list is ? for that i need to get the data in to some var How can i get that cells data?

2524

---

What is the use of the date function in the vbscript language?

1090

---

1) How can we use VB script in testing the application? 2) What all are the things(Software application to be installed in PC) we need to learn VBscript?

4062

---

Explain the extension .hta?

1012

---

What are the different types of loops available in the vbscript language?

1032

---

how does vb script help in web page designing? explain with example.

2038

---

Which operator can be used to change the value of the operand or change the state of the condition?

1076

---

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

1036

---