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 can I import environment from a file on disk?
Hi can anybody send me the QTP material, To my email ID: nuve1284@gmail.com ?
iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?
How do you delete unwanted results in qtp?
Which features or drawbacks of QTP lead to the upgrade for a newer version?
Discuss quicktest professional (qtp) environment?
How do client side image and server side image work?
Explain the parameter in qtp?
could any help me please, how to work on visual foxpro application using UFT
can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?
What are the different recording modes?
Is any limitation to xml checkpoints?
How to do call a output parameter from one action to another action??/
What are the features and benefits of quick test pro (qtp 8.0)?
Presently i am working on QTP 8.2 Version,i want to know features in 9.2 version, because i have not sufficient time to put the effort on the 9.2 version