how to open Excel sheet & write in it & save it?
Answer Posted / 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 |
Post New Answer View All Answers
how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)
what is the frame work in J-meter?
How Can I find the least value in a bunch of variables using qtp.. E.g.:- A = 210, B = 212, C = 60, D = 111 I don’t want to write bunch of lines for this…. Is there a way to get the result in one line…..
what is actually contain test report? can anybody post the test report
What r the different filters in defect in quality center
Explain the concept of object repository & how qtp recognizes objects?
is there any addin for remedy user application
If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?
How to open a new test using quicktest professional?
What are the features supported by UFT?
what is ODC and GDC?
What is test object?
Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints
Explain how you can replace string in qtp?
Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance