EasyXLS

Format.bas

Attribute VB_Name = "Format"
Public FORMAT_FORMAT_GENERAL As String
Public FORMAT_FORMAT_INTEGER As String
Public FORMAT_FORMAT_FLOAT_2DECIMALS As String
Public FORMAT_FORMAT_INTEGER_PERCENT As String
Public FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT As String
Public FORMAT_FORMAT_DATE As String
Public FORMAT_FORMAT_DATE_TIME As String
Public FORMAT_FORMAT_CURRENCY As String
Public FORMAT_FORMAT_AS_HALVES As String
Public FORMAT_FORMAT_AS_QUARTERS As String
Public FORMAT_FORMAT_AS_TENTHS As String

Sub Initialize()
    FORMAT_FORMAT_GENERAL = "General"
    FORMAT_FORMAT_INTEGER = "0"
    FORMAT_FORMAT_FLOAT_2DECIMALS = "0.00"
    FORMAT_FORMAT_INTEGER_PERCENT = "0%"
    FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT = "0.00%"
    FORMAT_FORMAT_DATE = "MM/dd/yyyy"
    FORMAT_FORMAT_DATE_TIME = "MM/dd/yyyy HH:mm:ss"
    FORMAT_FORMAT_CURRENCY = "$0.00"
    FORMAT_FORMAT_AS_HALVES = "# ?/2"
    FORMAT_FORMAT_AS_QUARTERS = "# ?/4"
    FORMAT_FORMAT_AS_TENTHS = "# ?/10"
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