that would be simple buddy
like open your excel manually and in that click on VIEW option and click on MACRO under which click on RECORD MACRO
–now do the sorting manually in the excel meanwhile that steps will be recorded in the background and will get converted into relevant VB Script
–once after performing the process of sorting in excel at the left bottom of the excel screen we can see a small black square box and on pressing that the macro recording will be stopped.
–now click again on MACRO and VIEW MACRO and EDIT option
–which will open the macro and copy that and paste it in a txt file
–now use a INVOKE VBA activity inside the EXCEL APPLICATION SCOPE and mention the filepath of that txt file as input and method name as well
Cheers @Naveen.Ch