i ve an excel in a QC folder. Thru my QTP script i want to
open that excel in runtime. I am running this script from
QC itself

Answer Posted / 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)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?

1387


Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.

1484


what is clean sweep?

1502


Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar

2788


Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!

2433






what is the diff between manual test plan document and automation test plan doc.can u explain indetail.

1632


What is the file extension of the code file in qtp?

554


Hi How to retrieve data from web element line by line?

1566


In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail

1491


How can you identify the browser and its information using the qtp script?

571


what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana

1447


How to replay a script in qtp?

605


Explain runtime dynamic settings?

2016


What is the syntax to call one script from another?

525


how to test load test and block box testing an a web based application pls give ans briefly

1345