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 driver-script and AOM-script?

2 Answers   IBM, Value Labs,

---

After the execution of a script how do u upload the results to Quality Center. Pls anyone explain in detail. It is very urgent._______Thanks a lot!!

2 Answers   ABC,

---

What r the advantages of automation?

3 Answers  

---

when i add the items to the repositry, the item is loading is "winmenu", but wn i write the script the tool is not able to recognise the item, i know that we need to define the mandatory or assitive properties here, but i am confused wt i need to difine here and on wt basis i need to select the properties and define it, can any one help me out on this.

0 Answers  

---

Can we directly automate testscripts accrdoing to requirements

2 Answers   CitiGroup, Novartis,

---

---

What are the things(properties, and other details) will be recorded while recording an object using normal recording?

0 Answers  

---

How to connect to the Database from QTP?

10 Answers   DB, Thatavarti Technologies, Xchanging,

---

What is the difference between Action and Function.? when both has the same functionaltiy, when do we choose Action and when do we choose Function..??

3 Answers   DST Global Solutions,

---

Is the qtp course will help to create a virtual object?

0 Answers  

---

suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query

1 Answers   IBM,

---

How to load an object to a object repository at RUN TIME ?

3 Answers  

---

For Usability testing, which is preferable Automation or Manual?

6 Answers  

---