Export Excel file and grouping rows or columns in sheet using EasyXLS component! XLSX, XLSM, XLSB, XLS file in VB6.
https://www.easyxls.com/manual/tutorials/vb6/excel-group-rows-columns.html