Answer Posted / bharathchandra maddhi

Option explicit
Dim exo, wbo, wso1, wso2, nor, noc, i, j, x, y
'Open a Excel file
Set exo=CreateObject("excel.application")
exo.Visible=true
Set wbo=exo.Workbooks.Open("C:\Bharath.xls")
Set wso1=wbo.Worksheets("sheet1")
Set wso2=wbo.Worksheets("sheet2")
nor=wso1.usedrange.rows.count
noc=wso1.usedrange.columns.count
'Varifying excel sheet strings
For i=1 to nor step 1
For j=1 to noc step 1
x=wso1.cells(i,j)
x=cstr(x)
If strcomp(x,"Bharath")=0 Then
wso2.cells(1,1)=x
End If
Next
Next
'Close excel s/w and Destroy the objects
exo.Quit
Set wso1=Nothing
Set wso2=Nothing
Set wbo=Nothing
Set exo=Nothing

How to integrate the qualitycenter with qtp

2200

---

Do you know SQL? I know SQL but i don't have any experience...that's it..No more questions ...simply he said " you can leave for the day" ...guys prepare SQL Quires before attending interview in bank of america...

1700

---

Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

1781

---

How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.

2191

---

What are the differences between table and db checkpoints?

959

---

what are the limitations of smart identification in qtp 9.0

2309

---

Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.

2101

---

How to use reporter.report event in qtp ?

972

---

whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

2073

---

breef description of batch testing ?

2067

---

Explain types of descriptive programming?

983

---

when to start the automation?

1896

---

What is the use of sendkeys and what are send keys

2408

---

Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project

2025

---

ACTUALLY I AM WORKING IN THE DISTRIBUTION DOMAIN.MY COMPANY IS PROVIDING DISTRIBUTION SOFTWARE FOR PHARMA AND FMCG DISTRIBUTORS.HERE I AM USING QTP 9.2.HERE IN MY APPLICATION WHILE RECORDING ONE WINDOW APPEARS.IN THAT I CAN SELECT THE ITEM OR NO NEED TO SELECT.BUT WHILE RUNNING THE SAME SCRIPT THE WINDOW MAY NOT APPEAR OR APPEAR.HOW TO WRITE SCRIPT FOR THIS

1908

---