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_REGIONAL_SETTINGS As String
Public FORMAT_FORMAT_DATE_WEEKDAY_REGIONAL_SETTINGS As String
Public FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS As String
Public FORMAT_FORMAT_DATE_TIME_REGIONAL_SETTINGS 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_REGIONAL_SETTINGS = "Short Date"
    FORMAT_FORMAT_DATE_WEEKDAY_REGIONAL_SETTINGS = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy"
    FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS = "General Date"
    FORMAT_FORMAT_DATE_TIME_REGIONAL_SETTINGS = "[$-F400]h:mm:ss\\ AM/PM"
    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:

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