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
- 27852 Views
- I also Faced
- E-Mail Answers
Answer Posted / dipti
Dim ExcelSheet, excelobj
Set ExcelObj = CreateObject("Excel.Application")
excelObj.visible = true
ExcelObj.Workbooks.Add
Set ExcelSheet = ExcelObj.Sheets.Item(1)
ExcelSheet.Cells(1,1).Value = "This is column A, row 1"
' Save the sheet.
ExcelObj.ActiveWorkBook.SaveAs "C:\TEST.XLS"
' Close Excel with the Quit method on the Application
' object.
ExcelObj.Quit
Set excelobj = nothing
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is object spy in quicktest professional?
How to execute a winrunner script in quicktest professional?
can the activities of test case design be automated?
What is the use of sendkeys and what are send keys
Mention the different actions types of qtp.
Hi, Can we open a test in qtp10 which is saved in qtp 9.2?
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
breef description of batch testing ?
What are the challenges u faced in testing with crm domain? How u overcome with?
what is the mail use of frame work(with detail). architecture for keyword driven frame work
Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji
I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible
How is the Bitmap checkpoint different from Image checkpoint?
How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
