Sorting the Data and Saving an Excel file before ftping it to UNIX server
 

Hi all,
i have a requirement where in
1.i have to sort the data in an excel sheet
2. create a .dat file and FTP the .dat file to UNIX server
3. Before FTPing the .dat file i have to save the excel macro in a
specified location

i am able to achieve the 2nd point but how do i go about the 1st and
3rd point? any pointers regarding the same will be highly appreciated.

Thanks
Narendar