EasyXLS

Footer.bas

Attribute VB_Name = "Footer"
Public FOOTER_POSITION_LEFT As String
Public FOOTER_POSITION_CENTER As String
Public FOOTER_POSITION_RIGHT As String

Sub Initialize()
    FOOTER_POSITION_LEFT = "L"
    FOOTER_POSITION_CENTER = "C"
    FOOTER_POSITION_RIGHT = "R"
End Sub

EasyXLS Excel components:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Download EasyXLS™ Excel Component for VB6

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT