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

What is the Difference between Environment variable and Globle variable,.. anybody can give me answer..Thanks in advance...

4 Answers   IBM,

---

I have 5 no.of Action in my Test. Out off which i should make 3rd action as my start-up action. How should i make it?

5 Answers  

---

How to perform action on objects, If two objects have the almost the same name ? example : Object 1 : "Entry of Items" Object 2 : "Items" Whenever I ask QTP to perform an action on Object 2 it performs action on Object 1. Note: The two objects are present in an Oracle Application tree.

2 Answers   Wipro,

---

How u do the back end testing in QTP?

2 Answers   HP, SunGard, TCS,

---

In the application that I'm testing is having a WYSIWIYG editor.QTP is recording editor's body as web element. I want to add some data to this web Element at run time. The problem is that I cant find a method to add contents to this web Element. Can any one come up with an answer for this. Thankx.

0 Answers  

---

Can we use same virtual objects in many number of tests?

1 Answers   TCS,

---

What is throw object?

1 Answers  

---

how qtp identifies objects of application.

5 Answers   Intel,

---

plz explain QTP real time work( Means where you store scripts and how u access scripts next day? where those activities we are maintaining, If By usig VSS how the process in going on , plz explain briefly?

2 Answers   CTS, Tech Mahindra,

---

What is TOM in QTP?

0 Answers  

---

Could you please explain me about QTP framework.

2 Answers   Oracle,

---

Please give me the steps to carry out datadriven in QTP8.2

2 Answers  

---