how to open Excel sheet & write in it & save it?
Answer / guest
Set excel = CreateObject ("EXCEL.Application")
excel.Caption = "Test Caption"
excel.Visible = True
Set doc = excel.Workbooks.Add()
Set selection = excel.Selection
With selection
.Cells(1,1).Value = "Test value"
End With
doc.SaveAs("E:\Excel.xls")
excel.Quit
| Is This Answer Correct ? | 10 Yes | 1 No |
can we run the scripts of qtp 8.2 in the qtp7.0?
Have you used xml check point in your project?
If the objects hierarchy is changing from build to build, then how you will handle that condition?
Which features or drawbacks of QTP lead to the upgrade for a newer version?
In QTP, As a first step wht we will do before going to start a Automation....when it will be decided that we have to go for a Automatio..and who will decide to go for Automation. Any body can pls let me know.. Thanks in Advance..
what is the extension for the test version of the script?
Hoe we can export TEST RESUALT IN to XL-sheet?
Hi all please solve this.It is urgent..... When I right clicked on a Web image manually It displayed Open link,open link in new window,save picture as, Email picture,Printpicture,propeties...etc. While automation I have written a code like this 'browser("Google").Page("ramseeker®: Memory and_3").Image ("graphOfModel").Click 10,10,micRightBtn But the right click menu was not displayed. I want to save that image in a seperate folder
How many types of parameters are available in quicktest professional?
any one could you explain the following code with example: intFieldItemsCnt =CInt(GetProperty(Browser ("Browsername").Page("Pagename").Weblist ("weblistname"),"items count")) msgbox intFieldItemsCnt
What is obsolute path and relative path in QTP..? How to access them and what are the differences between them...??
how qtp handles customised object