EasyXLS

ShadowFormat.bas

Attribute VB_Name = "ShadowFormat"
Public SHADOWFORMAT_TYPE_OUTER As Long
Public SHADOWFORMAT_TYPE_INNER As Long
Public SHADOWFORMAT_TYPE_PERSPECTIVE As Long
Public SHADOWFORMAT_NO_SHADOW As Long
Public SHADOWFORMAT_OFFSET_DIAGONAL_BOTTOM_RIGHT As Long
Public SHADOWFORMAT_OFFSET_BOTTOM As Long
Public SHADOWFORMAT_OFFSET_DIAGONAL_BOTTOM_LEFT As Long
Public SHADOWFORMAT_OFFSET_RIGHT As Long
Public SHADOWFORMAT_OFFSET_CENTER As Long
Public SHADOWFORMAT_OFFSET_LEFT As Long
Public SHADOWFORMAT_OFFSET_DIAGONAL_TOP_RIGHT As Long
Public SHADOWFORMAT_OFFSET_TOP As Long
Public SHADOWFORMAT_OFFSET_DIAGONAL_TOP_LEFT As Long
Public SHADOWFORMAT_INSIDE_DIAGONAL_TOP_LEFT As Long
Public SHADOWFORMAT_INSIDE_TOP As Long
Public SHADOWFORMAT_INSIDE_DIAGONAL_TOP_RIGHT As Long
Public SHADOWFORMAT_INSIDE_LEFT As Long
Public SHADOWFORMAT_INSIDE_CENTER As Long
Public SHADOWFORMAT_INSIDE_RIGHT As Long
Public SHADOWFORMAT_INSIDE_DIAGONAL_BOTTOM_LEFT As Long
Public SHADOWFORMAT_INSIDE_BOTTOM As Long
Public SHADOWFORMAT_INSIDE_DIAGONAL_BOTTOM_RIGHT As Long
Public SHADOWFORMAT_PERSPECTIVE_DIAGONAL_UPPER_LEFT As Long
Public SHADOWFORMAT_PERSPECTIVE_DIAGONAL_UPPER_RIGHT As Long
Public SHADOWFORMAT_PERSPECTIVE_BELOW As Long
Public SHADOWFORMAT_PERSPECTIVE_DIAGONAL_LOWER_LEFT As Long
Public SHADOWFORMAT_PERSPECTIVE_DIAGONAL_LOWER_RIGHT As Long
Public SHADOWFORMAT_ALIGNMENT_TOP_LEFT As String
Public SHADOWFORMAT_ALIGNMENT_TOP As String
Public SHADOWFORMAT_ALIGNMENT_TOP_RIGHT As String
Public SHADOWFORMAT_ALIGNMENT_LEFT As String
Public SHADOWFORMAT_ALIGNMENT_CENTER As String
Public SHADOWFORMAT_ALIGNMENT_RIGHT As String
Public SHADOWFORMAT_ALIGNMENT_BOTTOM_LEFT As String
Public SHADOWFORMAT_ALIGNMENT_BOTTOM As String
Public SHADOWFORMAT_ALIGNMENT_BOTTOM_RIGHT As String

Sub Initialize()
    SHADOWFORMAT_TYPE_NO_SHADOW = 0
    SHADOWFORMAT_TYPE_OUTER = 1
    SHADOWFORMAT_TYPE_INNER = 2
    SHADOWFORMAT_TYPE_PERSPECTIVE = 3
    SHADOWFORMAT_NO_SHADOW = 0
    SHADOWFORMAT_OFFSET_DIAGONAL_BOTTOM_RIGHT = 1
    SHADOWFORMAT_OFFSET_BOTTOM = 2
    SHADOWFORMAT_OFFSET_DIAGONAL_BOTTOM_LEFT = 3
    SHADOWFORMAT_OFFSET_RIGHT = 4
    SHADOWFORMAT_OFFSET_CENTER = 5
    SHADOWFORMAT_OFFSET_LEFT = 6
    SHADOWFORMAT_OFFSET_DIAGONAL_TOP_RIGHT = 7
    SHADOWFORMAT_OFFSET_TOP = 8
    SHADOWFORMAT_OFFSET_DIAGONAL_TOP_LEFT = 9
    SHADOWFORMAT_INSIDE_DIAGONAL_TOP_LEFT = 10
    SHADOWFORMAT_INSIDE_TOP = 11
    SHADOWFORMAT_INSIDE_DIAGONAL_TOP_RIGHT = 12
    SHADOWFORMAT_INSIDE_LEFT = 13
    SHADOWFORMAT_INSIDE_CENTER = 14
    SHADOWFORMAT_INSIDE_RIGHT = 15
    SHADOWFORMAT_INSIDE_DIAGONAL_BOTTOM_LEFT = 16
    SHADOWFORMAT_INSIDE_BOTTOM = 17
    SHADOWFORMAT_INSIDE_DIAGONAL_BOTTOM_RIGHT = 18
    SHADOWFORMAT_PERSPECTIVE_DIAGONAL_UPPER_LEFT = 19
    SHADOWFORMAT_PERSPECTIVE_DIAGONAL_UPPER_RIGHT = 20
    SHADOWFORMAT_PERSPECTIVE_BELOW = 21
    SHADOWFORMAT_PERSPECTIVE_DIAGONAL_LOWER_LEFT = 22
    SHADOWFORMAT_PERSPECTIVE_DIAGONAL_LOWER_RIGHT = 23
    SHADOWFORMAT_ALIGNMENT_TOP_LEFT = "tl"
    SHADOWFORMAT_ALIGNMENT_TOP = "t"
    SHADOWFORMAT_ALIGNMENT_TOP_RIGHT = "tr"
    SHADOWFORMAT_ALIGNMENT_LEFT = "l"
    SHADOWFORMAT_ALIGNMENT_CENTER = "ctr"
    SHADOWFORMAT_ALIGNMENT_RIGHT = "r"
    SHADOWFORMAT_ALIGNMENT_BOTTOM_LEFT = "bl"
    SHADOWFORMAT_ALIGNMENT_BOTTOM = "b"
    SHADOWFORMAT_ALIGNMENT_BOTTOM_RIGHT = "br"
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