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
Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
What are the challenges u faced in testing with crm domain? How u overcome with?
What is parameter in qtp?
write script for bitmap image?
Hi I know two types of testing processes. 1. Reaquirments stage,test design,code review's, Design review's, Test Plan, Test Cases design, test execution, Defect Reporting and tracking, UAT, Signoff. 2.Test Initiation , Test Plan, Test Design, Execution,Bug tracking, UAT, Sign off.
While spliting an action in QTP 10.0 getting an error : "This Line is a part of Script Block.You cannot split the action on this line." how to re-solve this and split the script into actions?
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya
can the activities of test case design be automated?
Your roles and responsibilities and daily tasks? (As automation tester)
Hi ,Can any one pleas explain how to test splash objects using QTP?
How qtp identifies objects?
How to create Reusable and Multiple Actions?
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
In QTP can we feed the out of one browser(internet explorer) as an input to the another browser(mozilla firefox)? If yes explain how to do it with an example.