Search This Blog

Wednesday 16 January 2013

Sorting Data in Excel Sheet ?

Dim exo,wbo,wso
Set exo=createobject("Excel.application")
Set wbo=exo.Workbooks.Open("E:\number.xlsx")
Set wso=wbo.Worksheets("Sheet1")
exo.Visible=true
wait(3)

Set objRange = wso.UsedRange
Set objRange2 = exo.Range("A1")
objRange.Sort(objRange2)
wbo.Save
exo.Quit
Set wbo=nothing
Set wso=nothing
Set exo=nothing

Note: Indicated "A1" as the starting point in Excel.

No comments:

Post a Comment