i have generated a report in excel format using ole automation methods. The generated excel contains two work sheets. I need to sort data in the second sheet by 2 specified columns using excel macro . The data starts from row 13 onwards where as i have 12th row as column headers. The data needs to be sorted before the sheet display.
Can any body advice me how to achive this.