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 my script there is a link(e.g. 'My Page') when I execute the script sometimes(not every time) QTP throws an error that "My Page(as link)" not found. Pleaase tell me where I need to update

3 Answers  

---

banking domain description for software tester for interview

0 Answers   Semantic Space,

---

Does QTP provides any tools for parametarization?

3 Answers   BirlaSoft,

---

Inserting a Call to Action is not Importing all columns in Datatable of globalsheet. Why?

4 Answers   Accenture,

---

What is AUT in object reposity in QTP? Why we use it in Object repository???What is full form???????

6 Answers  

---

I have java based application on my computer. Can I install QTP on it? What are system requirements for installing QTP?

3 Answers  

---

What is the extension of script and object repositary files?

2 Answers  

---

what is qtp automation frame work,what is the use of that frame work?

64 Answers   Cap Gemini, IBM, iGate, TCS,

---

I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”

0 Answers  

---

How we can differentiate between stand alone application and web application in QTP?

3 Answers   Deloitte,

---

Plze let me know how you can validate in the QTP that printed documents is correctly printed or not ie how we can do the validation that all the records or text are printed successfully in the printed document as per the application format requuired.

4 Answers   MBT,

---

What is the another extension name of library file. If that is exist than what's the difference between them.

2 Answers   Synechron,

---