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


Please Help Members By Posting Answers For Below Questions

How can I import environment from a file on disk?

537


Hi can anybody send me the QTP material, To my email ID: nuve1284@gmail.com ?

1691


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?

1605


How do you delete unwanted results in qtp?

604


Which features or drawbacks of QTP lead to the upgrade for a newer version?

572






Discuss quicktest professional (qtp) environment?

578


How do client side image and server side image work?

1390


Explain the parameter in qtp?

579


could any help me please, how to work on visual foxpro application using UFT

1687


can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?

1404


What are the different recording modes?

562


Is any limitation to xml checkpoints?

561


How to do call a output parameter from one action to another action??/

1872


What are the features and benefits of quick test pro (qtp 8.0)?

601


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

1410