Help for this page

Select Code to Download


  1. or download this
    #here's the macro
    Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess
    +, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
        Selection.Sort Key1:=Range("A1"), Order1:=xlDescending, Header:=xl
    +Guess, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    
  2. or download this
    my $file_name = 'FILE_NAME.xls';
    my $xl        = Win32::OLE->new('Excel.Application',
    ...
    $sheet1->{Name} = 'YOUR_SHEET_NAME';
    
    $book->SaveAs($file_name);