-
QTP : Inserting a text into a cell of an excel sheet
What will be the script to insert a text or value into a cell of an excel sheet ? Pls help...Thanks in advance.
kotike
- Apr 12th, 2010
Set oExcel=CreateObject("Excel.Application")set oWB=oExcel.WorkBooks.AddoExcel.visible=TrueoExcel.Cells(1,1)="All the Best.have a great day"set oWB=Nothingset oExcel=Nothing
prashanth.n
- Nov 30th, 2007
The following code will be useful for inserting text into excel.Dim appDim bookDim sheetSet app=CreateObject("Excel.Application")Set book=app.workbooks.open("e:temp.xls")Set sheet=book.activesheetsheet.cells(1,1)="hello"book.saveapp.quit
-
How to recognize the page in QTP?
Suppose there is a link on a web page. On clicking that link, 6 different web pages open in separate browser windows. The title of the page changes at run time. There is a text box on the sixth page. The name of the text box also changes at runtime.Requirement:Write a piece of code to access the text box and fill in your name in it.
Anshoo_Arora
- Dec 18th, 2007
Try this:Browser("micClass:=browser").Page("micClass:=Page").WebEdit("name:=regex.*", "index:=0").Set "SomeValue"Substitute regex (regular expression) a value that will match WebEdit description.
-
QTP Descriptive Program Objects List
How we can identify the descriptive program objects in GUI map of QTP8.2 Version
Anshoo_Arora
- Dec 8th, 2007
Have you added those objects to the GUI Map? Or, they have only been described in DP. If you answer "yes" for the latter, they won't appear in the GUI Map.
-
Executing any file in QTP
-
How to Pass variable in the sql query when creating DB Checkpoint
How can we pass a variable while creating a DB checkpoint. Is it even possible ?I would like to do something likeQTP scriptvariablename=somevalueDB Checkpoint query:select * from table where col=variablenameinstead of doing select * from table where col=123Thank youSairam
amninder
- Apr 25th, 2008
Set con=createobject("ADODB.Connection")con.connectionstring="DSN=QT_Flight32;DBQ=C:Program FilesMercury InteractiveQuickTest Professionalsamplesflightappflight32.mdb;Driver=C:WINDOWSsy...
ramugogurla
- Dec 23rd, 2007
hi sriram,i think we can pass variables from dataatbleselect* from table where datatable.value("columnno",1)
-
How to Create Database Checkpoint manually in QTP
Is it possible to write a sql query manually in the QTP script to create a DB checkpoint instead of going through the MS SQL QUERY tool ? thanks Sai
hpruthi
- Dec 26th, 2007
Yes it is possible to execute the query without using the "Microsoft Query". You just need to choose the other option in the Database Query Wizard i.e. "Specify SQL statement manually&q...
-
Call vbscript Function in QTP
How to call a function created by using vbscript in QTP
stevelink
- Feb 2nd, 2009
Greetings! In QTP 9.5, you can parameterize your user names and passwords, and then the script will run for each iteration and use the different user names and associated passwords. For example, ...
Neeraj Chauhan
- Jan 8th, 2008
Hi Can you specify wat you wanna to ask, plz According to me 1: There is a framwork where you keep your all files (scripting) After definin...
-
How to Submit data from an external file to a url using QTP
Hi,I would like to submit/load test data from an external source like a flat file or excel (multiple test cases in a file) and submit that test data to a url (application that I am testing). I need to capture the response that I get back from the application. Can I do that using QTP ? ThanksSai
RicGupta1984
- Mar 3rd, 2008
''creation of new sheet using import function:-'let say new sheet has two columns userid and password. v=DataTable.AddSheet ("newsheet").AddParameter ("ColumnName Time&...
latamindq
- Feb 27th, 2008
We can submit the external file in the data table using the import , when we change the script at the values, then by using the output value u can get the result in the run-time data table.
-
Analyse QTP Results
How to Analyse the QTP Results?
sadamp
- May 8th, 2008
nOnce the RUN is done ,it automaticallt shows the Results windowThat contains...Test Results Tree - an icon-based view of the steps that were performed while the test was running. Similar to the t...
ramu.makineni
- Feb 22nd, 2008
HiAfter completion of running the QTP we will get the results as below : Test Results Summary:Test:Product name:Results name :Time Zone: GMT Standard TimeRun started:Run ended:Result:If any thing wrong let me knowRam
-
QTP Scripts from Quality Center
How to run QTP Scripts from Quality Center
Arunkumar
- May 15th, 2012
This script Answer is: it will connect to QTP server first then the user will give the username and password and Enter in to the particular login page.
vickyviz
- Jan 29th, 2008
Firstly we got to download Mercury Quality Center Connectivity Addin and QuickTest Professional Addin Open QC,Create a new Subject in Test PlanThen place all your QTP scripts in folderOpen Q...
-
Test Object and Run Object
What is test object and run object in QTP?
ramugogurla
- Feb 20th, 2008
TestObject: It is nothing but the information which was learned by qtp and maintained in object repositoryrun Object:it is nothing but the object information which we are going to play backinorder to ...
srimathikarthik
- Feb 13th, 2008
Test Object is the objects in the objects repository that we have learned from the application.Run Object is the object in the application, while execution of scripts QTP compares the property of the Run object in the application to the Test Object property in the repository.
-
Read only excel file in QTP
How to create read only excel file using QTP?
ramugogurla
- Feb 20th, 2008
Dim fso, MyFileSet fso = CreateObject("Scripting.FileSystemObject")Set MyFile = fso.CreateTextFile("c:testfile.txt", True)MyFile.WriteLine("This is a test.")MyFile.Closewith this code u can create text file and also xl files
-
Debug QTP Automation Script
Have you *personally* debugged/developed any QTP/WR automation scripts using TSL from scratch? If yes explain
ganesh.kumar
- Apr 17th, 2008
Yes..1. Use the breakpoint where u want to Debug either by pressing F9 Button or Click on 'Insert breakpoint' in the Debug menu2. Run the Script by pressing either Run button or f53. QTP ...
NawabShaikh
- Feb 28th, 2008
Yes..1. Use the F9 button in QTP for setting up Debug point.2. While the script is executing it will stop at the debug point.3. Use the Expression/Variable window to get computation of Varibles and expressions.4. Use F10 for proceeding to next step.Regards,Nawab
-
Automate scripts in QTP under Mainframes Environment
Describe in detail, How to automate scripts in QTP under Mainframes Environment
asreddy29
- Mar 17th, 2008
Well, it depends on ur architecture. However, one can do thru blue-star software.Thru blue-star QTP can access your mainframe application (I guess). And secondly you also need recognise type of application (like whether it is text based or regulare gui based...etc)- by asreddy
-
Compare UAT with Production Web Page
How will you compare a web pages one in UAT and one in Production? Can you know what changes have been implemented in the UAT after the enhancement using QTP
Vishal Aggarwal
- Dec 14th, 2009
You can use different checkpoints like Page checkpoints and other checkpoints to verify their expected state to their actual state in the AUT.
-
Reusable Action
How reusable action can be implemented (process)
md_vinodh
- May 12th, 2008
In Keyword View , 1.select first Object in the Tree view Right click 2.select Action Properties. 3.Select the Check boxResuable action has selected then u can call the Action for other(Require) location
md_vinodh
- May 2nd, 2008
Hi, Using Resuable action , we can call the scripts more then one location / function flow
-
Find local host name using QTP
How to find local host name using QTP
avykunt
- May 23rd, 2008
This gives you the exact Answer :computername=Environment("LocalHostName")Msgbox computernameyou can access all these server name, operating system name, Local Host name from the S...
ramugogurla
- Apr 9th, 2008
Browser("yahoo").Urlit will give the current local hostor if u want any systemrelated information go for environment variables
-
Access a table row based on columns value
I have some information in table. for exampleTable table has four columns.It has two rows with following values in each columnscol1 col2 col3 col4val val12 val13 link1val21 val22 val23 link2I have a value stored in the data table as an out put value lets say val21 from an earlier pageOnce I am on this page I want to compare this value to the tables columns values. If I find...
fullmoon74
- Apr 15th, 2008
Thanks a lot nawab. I will try this tonight an will let you know how it goes.
NawabShaikh
- Apr 15th, 2008
There are two Approach for the same.1. Object Repository ''Suppose the Table is captured in OR For intCnt = 0 to Browser().Page().Frame().WebTable(Tbl).GetROProperty("ro...
-
How to find the Test Result Path at run time.
Hi All,I would like to know, how to get test result path at run time, mean to say in descriptive programming, Is there any method available for the same.I would be grateful to you for your help.Regards,Akshaya Madali
goldvels
- Apr 18th, 2008
There is one "Built-in Environment variable in QTP called "ResultDir".We can Get the test result path as below...a = Environment.Value("ResultDir")Ans:for ex: result path will be "C:Temp"
NawabShaikh
- Apr 17th, 2008
Set qtTest = qtApp.Test qtTest.Settings.Run.OnError = "NextStep" ' Instruct QuickTest to perform next step when error occurs Set qtResultsOpt = CreateObject("QuickTest.RunResultsOpt...
-
QTP Actions limit
How many actions can be created in a QTP script ?
parasuraj
- Aug 13th, 2012
it is 255 only... why because... Each action should contain one action sheet in data table....but the data table can have only 256 sheets..one is already assigned as Global..so remaining will b...
Dipak123
- Jun 24th, 2008
Theoritically we can say that there is no limitation in creating Actions in QTP.But Microsoft Excel supports only 256 sheets. A seperate local Data sheet will be created for every action. ...
QTP Interview Questions
Ans