EasyXLS

AlignmentFormat.bas

Attribute VB_Name = "AlignmentFormat"
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_TOP As String
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_MIDDLE As String
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_BOTTOM As String
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_TOP_CENTER As String
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_MIDDLE_CENTER As String
Public ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_BOTTOM_CENTER As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_LEFT As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_CENTER As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_RIGHT As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_LEFT_MIDDLE As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_CENTER_MIDDLE As String
Public ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_RIGHT_MIDDLE As String

Sub Initialize()
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_TOP = "top"
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_MIDDLE = "middle"
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_BOTTOM = "bottom"
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_TOP_CENTER = "topcenter"
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_MIDDLE_CENTER = "middlecenter"
    ALIGNMENTFORMAT_VERTICAL_ALIGNMENT_BOTTOM_CENTER = "bottomcenter"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_LEFT = "left"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_CENTER = "center"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_RIGHT = "right"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_LEFT_MIDDLE = "leftmiddle"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_CENTER_MIDDLE = "centermiddle"
    ALIGNMENTFORMAT_HORIZONTAL_ALIGNMENT_RIGHT_MIDDLE = "rightmiddle"
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