Answer / karishma

got to options and select folders tab and give path of the
folder where the excelsheet is present in QC
and then try out this:
x=PathFinder.Locate("Results.xls")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook2 = objExcel.Workbooks.Open(x)

Answer / saranya

hi manoj,

Try this. Even I am doing the same thing for my application.
First connect your QTP to QC. Then open the code which you
have saved in QC in QTP. Click on Test->settings(in QTP9.2
it will be File->settings) -> click on resource tab . In
that you can see a frame called DataTable. In that select
the option "Other Location" and click on the browse icon
beside that option. It will display you all the excel
sheets in QC. Select your Excel sheet. Now autopmatically
the excel sheet will be embedded to your code in
runtime.You need not include any code for this excel sheet
in your main code. (But do take care of the sheet names in
the excel sheet. It should be correctly mentioned in your
code.)

Answer / manoj

with that code we can open a new excel or even open an
excel that is saved in our system
but i want to open an excel (which is saved in Mercury
Quality Center ) during run time.

is there any piece of code to download the excel from
Mercury Quality Center to local machine during runtime?

Answer / giridhar reddy

Hi
try this one, I am not giving you the whole syntax because
if you start analyze you will get more information on this
right? thats why...

SystemUtil.Run "excel",""

if you have any doubts let me know

in flight reservation ex once u login, u go into next window where we hav an option of new, open and help etc.. how to fetch those options and to go to respectiv tab accordingly using qtp.. plz let me knw answer for tis as early as possible. Thanks in advance... asha

1 Answers  

---

What are the file extensions for per-action, shared object repository files and what is the extension for library files?

4 Answers  

---

How can we import into Excel "Details" ,"Result" ,"Time" parameters from within a Results Report which is generated after a Run error when a script is executed in QTP? Refer E.g below Status Functionality Description RunDate Fail Login User should be able to Login 12/3/2007 StartTime EndTime Details* 1:31:58 PM 1:32:29 PM (this one i want)

0 Answers  

---

1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?

0 Answers  

---

how to write code for to select all the checkboxs in the gmail i wrote code for my question but it didn't works any body suggest what wrong my code my code is Set chkboxDesc=Description.Create() chkboxDesc("type").value="chekbox" Set chboxcollection=Browser("name:=Gmail .*").Page("title:=Gmail .*").ChildObjects(chkboxDesc) For i=0 To chboxcollection.count-1 chboxcollection(i).set "ON" Next i was getting general run time error pls help me i am in learing stage

2 Answers  

---

Explain script generated after applying database check point?

2 Answers  

---

For what purpose to we use object repository in a application?also explain usage of obj.repository?

3 Answers  

---

How to integrate the qualitycenter with qtp

0 Answers   Wipro,

---

What are the differences between qtp and winrunner?

0 Answers  

---

How to handle run time errors?

9 Answers  

---

Can we install QTP on remote server and access it as a web application on other system (client place)? If so please let me know. Thanks in advance, Ravi

2 Answers  

---

Without integrating QC/Testdirector with QTP, is it possible to keep track of the defects?If yes how? How to export QTP results to an excel sheet?

0 Answers  

---