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
I want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!
after initiating one project for testing, when exacltly QTP tester role starts?
What are the types of environment variables in qtp?
how did u use automating testing tools in ur job?
Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
What are the challenges you faced during you entire life automation ?
How to handle Java tree in QTP?
What is qtpro? What is a quick test professional?
Can we access the java methods in qtp. Because my requirement is to access the swt(for eclipse an it is java code) methods in qtp is it possible?
What are the features supported by UFT?
hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.
What are the different types of functions available in qtp and explain ?
How to create runtime property for an object?
How to handle dynamic objects in quicktest professional?