Set auto-filter to cell range for Excel sheet using EasyXLS component! XLSX, XLSM, XLSB, XLS file in VBScript.
https://www.easyxls.com/manual/tutorials/vbs/apply-filter-excel.html