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

when a test case is written how u test using qtp

1655


How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

1478


What is the extension of qtp local repository?

576


can any boby tell me what is method or steps to connect the remote desk top by using QTP 9.2 version?

1625


What is quicktest professional?

559






Through array we can execute the testcase how ? give me example

1402


How the exception handling can be done using quicktest professional?

545


How will you handle java tree in qtp?

629


can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.

5108


How to find the name of the machine where you are running your automation scripts in qtp?

521


What is the parameterization?

580


How will you test a stapler?

599


Explain features of the latest version of qtp/ uft 12.1?

606


what is meant by source control?

1696


How many types of trigger events are there in qtp?

551