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

Give some brief idea about a) Active x check b) Alt property check c) Applet object check d) Frame object check e) Multimedia links check f) Server side image check g) Table object check

1 Answers   CTS,

---

When to use shared and local object repository?

0 Answers  

---

in Qtp,how to display user name and pwd (script)in data table(global sheet).

2 Answers  

---

Hi I have a doubt in qtp. Can you please clarify my doubt. If we are importing the data from excel sheet in qtp the the script is running the number of row times. I mean if there are 4 rows in excel sheet the script is running 4 times. cant we avoid this. suppose i have tis script: datatable.Import "C:\Documents and Settings\sailaja\My Documents\login1.xls" n = datatable.GetRowCount For i =1 to n systemutil.Run "C:\Program Files\Mercury Interactive\QuickTest Professional\samples\flight\app\flight4a.exe" datatable.SetCurrentRow i Dialog("Login").WinEdit("Agent Name:").Set DataTable ("Username", dtGlobalSheet) Dialog("Login").WinEdit("Password:").Set DataTable ("Password", dtGlobalSheet) Dialog("Login").WinButton("OK").Click Window("Flight Reservation").ActiveX ("MaskEdBox").Type "020209" Window("Flight Reservation").WinComboBox("Fly From:").Select "Frankfurt" Window("Flight Reservation").WinComboBox("Fly To:").Select "Los Angeles" Window("Flight Reservation").WinButton("FLIGHT").Click Window("Flight Reservation").Dialog("Flights Table").WinButton("OK").Click Window("Flight Reservation").WinEdit("Name:").Set "Sailaja" Window("Flight Reservation").WinButton("Insert Order").Click Window("Flight Reservation").WinMenu ("Menu").Select "File;New Order" window("Flight Reservation").Close next I created a excel sheet with 3 rows and 2 columns. (username and password). The script is running 9 times. I made the option run one itaration only . eventhough it is running 9 times .can u plaese clarify my doubt. Thankyou Sailaja.

3 Answers  

---

1. Can anyone help me with recovery scenarios, each type with examples and also what is on error resume next?

1 Answers  

---

What are the automation metrice in your project?

0 Answers   Accenture,

---

why we use environment variables

5 Answers  

---

What is difference in global and action sheet in qtp?

0 Answers  

---

anyone can explain about "Smart Identification" in QTP I mean what is the use of "Smart Identification" Give an example

2 Answers  

---

can we run the scripts of qtp 8.2 in the qtp7.0?

2 Answers  

---

What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?

0 Answers  

---

How to open an application through scripting?

11 Answers  

---