Skip to Content
Former Member
Oct 28, 2009 at 06:06 AM

How to sort data in excel sheet using ole automation method



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.