Sort With Excel automation

[Stephane_Vabois]

Does anyone know the instruction to sort a excel file with navision automation control ? Thanks.

[ajayjain]

go in excel file make a macro sort the field and see the code by edit the macro and use that code