regarding vbscript

[priya]

can u pls help me how to sort an excel sheet using vbscript.The excel sheet contains only one column and around 500 rows.Now i need to sort it out in alphabetical order using VBScript

[rich96]

your going to have to use VBA. if your not very familar with the code let me give you steps on how to let Excel create the 'code' for you.

First open up the spreadsheet.
Then goto Tools - > Macro - > Record New Macro.
Do your sort (Data - > Sort) Or whatever formating
Then go back up to Tools - > Macro - > Stop Recording Macro
Then you will need to go to Tools - > Macro - > Visual Basic Editor

you can view/change the code under the module folder.

Or you can use this code below in a Module. this is simple sort macro.

Cells.Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Hope this helped.