Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hi
I am new to QTP. we are planning to implement automation
for the application.
I am trying to execute the following script:
Set ExcelObj=CreateObject ("Excel.Application")
ExcelObj.WorkBooks.Add
Set NewSheet=ExcelObj.Sheets.Item(1)
NewSheet.Name="Order"
ExcelObj.Cells(1, 1).Value = "Name"
ExcelObj.Cells(1, 2).Value = "Ordernum"
ExcelObj.Cells(2, 1).Value = "nam"
ExcelObj.Cells(2, 2).Value = "21"
ExcelObj.ActiveWorkbook.SaveAs "c:\test1.xls"
ExcelObj.Quit
Set ExcelObj = Nothing

in the above script for the line(ExcelObj.Cells(2, 2).Value
= "21")
it is inserting the value 21 successfully.this is fine
But if i want to insert a variable instead of the constant
value then what should be the modification in the script.

For example: If user retrives a value
throug "GetRoProperty" and wants to insert the value into
then how the script changes?



Hi I am new to QTP. we are planning to implement automation for the application. I am trying to ..

Answer / sri

Hi...don't mind...QTP Questions, u can post in Automation
Tools Section...this Section is only for Manual Testing!!!

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

If there are 10 notepads opened on desktop. how can we close a particular 2nd notepad using script

3 Answers  


Diff b/w test scenario's and test Procedures?

0 Answers  


How do we run the scripts in QTP ?? what are the three options....

4 Answers   HCL,


Pls Solve Error(SAP-CRM):- Cannot identify the specified item of the SAPNavigationBar object.Canfirm that the specified item is included in the object's item collection.

1 Answers  


How to capture the tooltip of webelement,if there are two values displayed in tooltip of webelement?

1 Answers  


I want to export the datasheet to excel.Instead of total file it exports only data without headers.How to solve this problem?

1 Answers   FAI,


Hi, I have a login page. To login in that page I need to have a valid username and password, which is stored in database. I imported that table to my DataTable in QTP (Global sheet). Now I need to write a code in qtp so that I can login only with valid username and data. my condition is : I want to get username and password from inputbox(which i did) and click on login button- which should verify the datatable for username and password and if value is present only then lofin else stop the testing. DataTable contains columns : LoginName and Password Code: Rowcount= DataTable.GetSheet("Global").GetRowCount msgbox "RowCount= " &RowCount,1 CurrentRow= DataTable.SetCurrentRow(1) Do Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$UserName$ctl").Set DataTable("LoginName",1) Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct l00$ctl00$Password$ctl").Set DataTable("Password",1) Browser("").Page("").Frame("Frame").Link("Login").Cli ck CurrentRow=CurrentRow+1 Loop Until CurrentRow>Rowcount Can anyone help? Thanks, Priya

3 Answers  


What are the various versions of QTP that have been released so far? Please also mention the year of release for each version

4 Answers  


Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

0 Answers   IBM,


What is a recovery scenario?

0 Answers  


what is descriptive.create()in qtp?

3 Answers  


write a qtp script to see time in windows command prompt? its urgent....

9 Answers   BSL,


Categories