Export data to Excel with cell formatting in VB6 using EasyXLS component! XLSX, XLSM, XLSB, XLS spreadsheets in VB6.
https://www.easyxls.com/manual/tutorials/vb6/format-excel-cells.html