EasyXLS

Table.bas

Attribute VB_Name = "Table"
Public TABLE_MAX_ROWS_OFFICE_97_2003 As Long
Public TABLE_MAX_COLUMNS_OFFICE_97_2003 As Long
Public TABLE_MAX_ROWS As Long
Public TABLE_MAX_COLUMNS As Long
Public TABLE_LOOK_IN_FORMULAS As Long
Public TABLE_LOOK_IN_VALUES As Long
Public TABLE_LOOK_IN_COMMENTS As Long

Sub Initialize()
    TABLE_MAX_ROWS_OFFICE_97_2003 = 65536
    TABLE_MAX_COLUMNS_OFFICE_97_2003 = 256
    TABLE_MAX_ROWS = 1048576
    TABLE_MAX_COLUMNS = 16384
    TABLE_LOOK_IN_FORMULAS = 0
    TABLE_LOOK_IN_VALUES = 1
    TABLE_LOOK_IN_COMMENTS = 2
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