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
What is the quicktest professional (qtp) testing process?
What is the synchronization point in qtp?
hou can we use vb script in qtp could u tell me breafly
please any one can explain the keyword driven framework. with gmail example.
How to handle Java tree in QTP?
How to find the length of the string in qtp?
How to replay a script in qtp?
In qtp, explain what is keyword driven automation framework?
how many maximum number of virtual users we can create?
On the website, the protocol has been changed https: to https what you will do? Tell me your approach?
For QTP Test Engineer, What is his contribution to the Project? Means, As as automation test engineer what is his role in the current project?
Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.
What is object repository in qtp?
What is the XML file architecture ?
Dear Friends, I having total 3+year experience in manual testing including automation testing QTP, if i am attending any interview what kind of question will i get? please help me out