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 |
how do you remove object repository at runtime and load object repository and verify it
Why you are Using Descriptive programming instead of Object Repository?
What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?
what is descriptive.create()in qtp?
How to add verification steps to tests?
Explain about the test fusion report of quicktest professional?
It is given in the help of QTP 9.2 that we cant debug the scripts. Is there any other way to VIEW, PAUSE and make modifications in the scripts during execution???
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
What are SetToProperty, SetRoProperty, GetToProperty scripting?
In an Excel sheet take two fields as agentname and password and type some valid agentname and password.call that excel sheet in qtp so that qtp opens the flightreservation window taking into consideration how many records are entered in the excel sheet.For example if 3 records are entered today it will open 3 FR windows,if in near future the records are more than 3 then it will open that number of times.
How to capture all the data of a webtable, weblist and combolist using QTP?
Up to how much VB scripting knowledge and what type of VB script knowledge is required for a QTP test engineer for real time to work ?