Answer Posted / dwarapudi.mca

Dim arr
n=inputbox("Enter Array size")
ReDim arr(n)
For i=0 to n
arr(i)=cint("1")+Cint(i)
Next
Set Excl=CreateObject("Excel.Application")
Excl.workbooks.open("C:\Ex.xlsx")
Set ExclSht=Excl.Sheets.Item("Sheet1")
LOP=int((Ubound(arr)/cint(26))+1)
For i=0 to LOP
For j=0 to 25
If (j+k)<=ubound(arr) Then
ExclSht.cells(i+1,j+1)=arr(j+k)
else
Exit for
End If
Next
k=k+j
Next
Set ExclSht=nothing
Set Excl=nothing



Please let me know if u have simplest answer than this.

Thx

To retrive the test data which tool vl use and whats basis u vl write test data? its urgent

1904

---

Explain calling sub procedure.

1070

---

hi, FOR 3+ QTP INTERVIEW, FOR EXAMPLE WE PUT ONLINE BANKING SYSTEM PROJECT IN OUR RESUME, IN PROJECT MANAGER ROUND...WHAT R THE MAJOR QUESTIONS ARE ASKED IN P.M? PLS TELL ME ATLEAST 10 QUESTIONS?.....AND IF POSSIBLE POST ANSWERS ALSO....

2919

---

How to handle Java tree in QTP?

1328

---

How to add verification steps to tests?

9759

---

Is it possible to change the values of analog recording?

1129

---

How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?

1143

---

Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

1902

---

How to get the particular property value?

1050

---

how did u use automating testing tools in ur job?

1966

---

Problem with XML checkpoint in QTP ?

3918

---

how to do the batch testing in test director using manual testing procedure?

2377

---

What are the differences between table and db checkpoints?

1018

---

What is the standard timing delay for web based application in qtp?

1082

---

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

2090

---