for each search_data in ows.usedrange if search

i have batch scripts in qtp and i want to update the status
like pass/fail in excel sheet after excecuting the every
script in batch.how to write the script for this?

Question Posted / nihar ranjan

1 Answers
6234 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / nihar ranjan

for each search_data in ows.usedrange
if search_data="fail" then
search_data.color.index="3"
else
search_data.color.index="4"
end if
next

Is This Answer Correct ?

0 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to release all resources file from the QTP?

1495

Explain how you can delete excel file in qtp?

996

What are the views available in quicktest professional?

975

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

2198

Explain about the quicktest professional (qtp) automation object model?

942

Explain types of output values?

964

How to find the difference between 2 dates in qtp?

990

Explain quicktest professional testing process?

955

How we can import data from database?

1150

How to remove associated function library?

938

In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail

1999

Is it possible to call from one action to another action in qtp?

977

how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1867

What are the types of environment variables in qtp?

983

banking project description for software tester

7422