help needed !

[neotrio]

hi all,

following script is supposed to sort the elements of excel sheet column.

Dim $excel=ObjCreate("excel.application")

$excel.visible=1

$excel.WorkBooks.Add ; Add a new workbook

$excel.ActiveWorkBook.ActiveSheet.Range("A1:A5").Select

$excel.ActiveWorkBook.ActiveSheet.Cells(1,1).Value="hello" ; Fill a cell

$excel.ActiveWorkBook.ActiveSheet.Cells(2,1).Value="Cello" ; Fill a cell

$excel.ActiveWorkBook.ActiveSheet.Cells(3,1).Value="Dello" ; Fill a cell

$excel.ActiveWorkBook.ActiveSheet.Cells(4,1).Value="Aello" ; Fill a cell

$excel.ActiveWorkBook.ActiveSheet.Cells(5,1).Value="Bello" ; Fill a cell

;$Key1=$excel.ActiveWorkBook.ActiveSheet.Columns("A")

$excel.ActiveWorkBook.ActiveSheet.Range("A1:A5").Select.Sort("A")

;$excel.ActiveWorkBook.ActiveSheet.Sort.Ascending.Range("A1:A5").Select = 1

$excel.ActiveWorkBook.Saved = 1

[SmOke_N]

Might help if you post your support question in the support forum.

Also, use [ code] [ /code] tags (without spaces) when posting code vs. using bold print to represent it (easier on the eyes).