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

For QTP Test Engineer, What is his contribution to the Project? Means, As as automation test engineer what is his role in the current project?

0 Answers   V2 Solutions,

---

Can we call a parameter from an action to other action?

4 Answers  

---

Object recognition in QTP is based on which model ? a) COM b) DCOM c) DOM d) None of the above

2 Answers   Ordain Solutions,

---

What is the entry and exit point of automation testing

2 Answers   Infosys,

---

Why a framework is needed?? Plaese post your answers ASAP

3 Answers   ACC, FD, Mphasis,

---

how to retrieve data from flight resevation->reports

2 Answers   Wipro,

---

How many ways we can parameterize data in quicktest professional (qtp)?

0 Answers  

---

Can we create test script with out Step Generator?

4 Answers  

---

Hi, this is venkatesh. Q: I have 10 files in a folder(say D:\). Out of which there are some .txt, .xls, .doc. I want to know how to get the count of each file using qtp? If U have any ans, plz write script for that...

4 Answers   EDS,

---

write a function to read the items from Combobox of Flight Reservation application and save in excel.

5 Answers  

---

How Can I find the least value in a bunch of variables using qtp.. E.g.:- A = 210, B = 212, C = 60, D = 111 I don’t want to write bunch of lines for this…. Is there a way to get the result in one line…..

0 Answers  

---

How many function you use in your application?

2 Answers   Polaris,

---