EasyXLS

ErrorType.bas

Attribute VB_Name = "ErrorType"
Public ERRORTYPE_NULL As Long
Public ERRORTYPE_DIV0 As Long
Public ERRORTYPE_VALUE As Long
Public ERRORTYPE_REF As Long
Public ERRORTYPE_NAME As Long
Public ERRORTYPE_NUM As Long
Public ERRORTYPE_NA As Long

Sub Initialize()
    ERRORTYPE_NULL = 0
    ERRORTYPE_DIV0 = 7
    ERRORTYPE_VALUE = 15
    ERRORTYPE_REF = 23
    ERRORTYPE_NAME = 29
    ERRORTYPE_NUM = 36
    ERRORTYPE_NA = 42
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