Create Excel with header & footer in VB6 by EasyXLS component! XLSX, XLSM, XLSB, XLS files in VB6.
https://www.easyxls.com/manual/tutorials/vb6/excel-footer-header.html