Interested to Buy Any Domain ? << Click Here >> for more details...
Dim ExcelSheet
Set ExcelSheet = CreateObject("Excel.Application")
excelsheet.application.visible = true
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column
A, row 1"
' Save the sheet.
ExcelSheet.SaveAs "C:\DOCS\TEST.XLS"
' Close Excel with the Quit method on the Application
object.
ExcelSheet.Application.Quit
after run this script i am getting error"The test cannot
continue due to unrecoverable error"
- 3 Answers
- 27849 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
hi friends
Try this code. it must work.
setexcel=createobject("excel.application")
setexcelsheet=createobject("excel.sheet")
excelsheet.application.visible=true
excel.activesheet.cells(1,1).value=1111
excel.activesheet.cells(1,2).value=2222
excel.activesheet.cells(2,1).value=1111
excel.activesheet.cells(2,2).value="aaaa"
excelsheet.saveas "c:\xyz.xls"
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Can I change properties of a test object?
Where can I find and view run-time data table?
What is checkpoints for quicktest professional (qtp)?
how can we test the Triggers, Cursors, Indexes while doing Database testing in DTP??
i have asked earlier only one question how to test web application using QTp plz send me the answer quickly
Difference between action & Reusable action?
I want to read XML file loaded in Quality center and compare the values with the values displayed in Application (web table).How can I do that
How to open a new test using quicktest professional (qtp)?
When to use shared and local object repository?
What is the parameterization?
Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji
How often were they executed?
in a web page hoe to check the dynamic links that rechabging with out using regular expressions
How can you write the scripts that operate on different objects depending on run-time information?
Explain the benefits of quick test pro(qtp)?
