hi friends Try this code. it must work. setexcel=createobject(&qu

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"

Question Posted / abhishek

3 Answers
27723 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

Please Help Members By Posting Answers For Below Questions

Explain how you can find the absolute value of the number in qtp?

1019

What is post recovery scenario?

2191

How many types of recording modes in qtp? Describe each type with an example where we use them?

976

An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?

950

Explain different recording modes?

967

Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

973

What are the properties you would use for identifying a browser and page when using descriptive programming?

967

Brief the process of testing with UFT?

1015

How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

1203

describe some problems that u had with automating testing tool?

1749

Does QTP record on Objects created on XWindows Environment?

2133

What are the ways you can synchronize?

998

What are private functions in QTP? How they can be called from the function library?

978

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

942

Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?

2026