[SOLVED] How to use _Excel_RangeSort to sort my excel file

[nooneclose]

How to use _Excel_RangeSort to sort my excel file by three different headers Column A1, B1, and C1 have headers on which I want to sort by. The headers on which I want to sort are department, employee type, and name.

I still really new to AutoIt so I do not actually know how to properly start this line or lines of code, to be honest. The example code is the best I can do.

_Excel_RangeSort($OpenWorkbook, Default, "A1:C1", "1:1", $xlDescending, Default, $xlYes, Default, $xlSortRows)

I just need to sort by those three headers in that order of department, employee type, and name, plus in descending order.

 

any and all help would be greatly appreciated.  Thank you!

Edited November 1, 2018 by nooneclose

[water]

_Excel_RangeSort($oOpenWorkbook, Default, Default, "A:A", $xlDescending, Default, $xlYes, Default, Default, "B:B", $xlDescending, "C:C", $xlDescending)

Can't test at the moment but I think it should work this way

Edited August 13, 2018 by water

[nooneclose]

It worked! well in the opposite order that I need lol  even so it works! thank you very much. I think I can get it in the correct order now, I hope. Just need to go from Z-A to A-Z. I know I asked for descending I got them confused, I meant Ascending, my bad. 

Thanks, Water you da best. 

Edited August 13, 2018 by nooneclose

[water]