Answer / 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

If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time

5 Answers   CTS,

---

A question was asked in a company-suppose, I am testing a website on QTP, all the time a new title bar is appeared on next page. Trying to use regular expression under key word driven testing but expert view is also appearing unchanged and error is also generating, do you have any best resolution for that kindly explain in detail. please dont give example of yahoomail, that is unable to clear my doubt.

2 Answers  

---

what are the different kinds of frameworks in automation?

1 Answers   Accenture,

---

in a web page hoe to check the dynamic links that rechabging with out using regular expressions

0 Answers   CTS,

---

Hi, I have weblist which contains the data like Design change,admin edit and cost saving etc.. User doesn't know the values existed in weblist. Now the user has to select the right value from the list otherwise the test will fail. Pls help me "To select the correct value from the list"

1 Answers  

---

In qtp, how you can exit for loop?

0 Answers  

---

Difference between test object and run time object?

0 Answers  

---

when i add the items to the repositry, the item is loading is "winmenu", but wn i write the script the tool is not able to recognise the item, i know that we need to define the mandatory or assitive properties here, but i am confused wt i need to difine here and on wt basis i need to select the properties and define it, can any one help me out on this.

0 Answers  

---

Tell me the situations where we will use Data Driven?

4 Answers   Ordain Solutions,

---

If we are record a same web page for 2 times.1st time it is showing 6 objects in the Object Repository and for the 2nd time it is showing like 7 Objects in the Object Repository why it is happening

4 Answers   Kanbay,

---

what are inputs for automation?

3 Answers  

---

difference between do while and do until ?

3 Answers   HCL,

---