next »

[punj prakash]

I used below code , as given in the user guide of QTP , but its giving "General error" on 2nd line.

Dim ExcelSheet
Set ExcelSheet = CreateObject("Excel.Sheet")'giving General error
' Make Excel visible through the Application object.
ExcelSheet.Application.Visible = True
' Place some text in the first cell of the sheet.
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
' Release the object variable.
Set ExcelSheet = Nothing

[Asiq Ahamed]

Hi Prakash,
        What you have written is correct, but MS excel application should be opened before you create Set ExcelSheet = CreateObject("Excel.Sheet") object.

Code

GeSHi (qtp):

Set ExcelObj=CreateObject ("Excel.Application")

Dim ExcelSheet

Set ExcelSheet = CreateObject("Excel.Sheet")

' Make Excel visible through the Application object.

ExcelSheet.Application.Visible = True

' Place some text in the first cell of the sheet.

ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1"

' Save the sheet.

ExcelSheet.SaveAs "C:\Documents and Settings\Desktop\TEST.XLS"

' Close Excel with the Quit method on the Application object.

ExcelSheet.Application.Quit

' Release the object variable.

Set ExcelSheet = Nothing

Set ExcelObj=Nothing

 

Created by GeSHI 1.0.7.20

[punj prakash]

Thanks

[punj prakash]

Can you tell me why is it happening?We have made ExcelObj object , but did not use it.( eg
In ExcelSheet.ActiveSheet.Cells(1,1).Value ,Activesheet method support directly ExcelSheet object. why we had to create Application (ExcelObj)object for ExcelSheet.Application.Visible.It should work directly.

Please clarify ...thanks!

[Asiq Ahamed]

Hi Prakash,
        This is simple,

Set ExcelObj=CreateObject ("Excel.Application")-For MS Excel Application.
Set ExcelSheet = CreateObject("Excel.Sheet")-For Sheet, not for the application.

We cannot create sheet object unless the application object is created/invoked. You can also distinguish these objects using Application.Visible property.

ExcelSheet.Application.Visible = True'Here your sheet will be visble on excel application

ExcelObj.Application.Visible = True'But here excel application will be visible not your sheet.

Hope this clarifies you!