EXCEL VBA常数设定

'Enum Constants

    Public Const xlAll = &HFFFFEFF8

    Public Const xlAutomatic = &HFFFFEFF7

    Public Const xlBoth = 1

    Public Const xlCenter = &HFFFFEFF4

    Public Const xlChecker = 9

    Public Const xlCircle = 8

    Public Const xlCorner = 2

    Public Const xlCrissCross = 16

    Public Const xlCross = 4

    Public Const xlDiamond = 2

    Public Const xlDistributed = &HFFFFEFEB

    Public Const xlDoubleAccounting = 5

    Public Const xlFixedValue = 1

    Public Const xlFormats = &HFFFFEFE6

    Public Const xlGray16 = 17

    Public Const xlGray8 = 18

    Public Const xlGrid = 15

    Public Const xlHigh = &HFFFFEFE1

    Public Const xlInside = 2

    Public Const xlJustify = &HFFFFEFDE

    Public Const xlLightDown = 13

    Public Const xlLightHorizontal = 11

    Public Const xlLightUp = 14

    Public Const xlLightVertical = 12

    Public Const xlLow = &HFFFFEFDA

    Public Const xlManual = &HFFFFEFD9

    Public Const xlMinusValues = 3

    Public Const xlModule = &HFFFFEFD3

    Public Const xlNextToAxis = 4

    Public Const xlNone = &HFFFFEFD2

    Public Const xlNotes = &HFFFFEFD0

    Public Const xlOff = &HFFFFEFCE

    Public Const xlOn = 1

    Public Const xlPercent = 2

    Public Const xlPlus = 9

    Public Const xlPlusValues = 2

    Public Const xlSemiGray75 = 10

    Public Const xlShowLabel = 4

    Public Const xlShowLabelAndPercent = 5

    Public Const xlShowPercent = 3

    Public Const xlShowValue = 2

    Public Const xlSimple = &HFFFFEFC6

    Public Const xlSingle = 2

    Public Const xlSingleAccounting = 4

    Public Const xlSolid = 1

    Public Const xlSquare = 1

    Public Const xlStar = 5

    Public Const xlStError = 4

    Public Const xlToolbarButton = 2

    Public Const xlTriangle = 3

    Public Const xlGray25 = &HFFFFEFE4

    Public Const xlGray50 = &HFFFFEFE3

    Public Const xlGray75 = &HFFFFEFE2

    Public Const xlBottom = &HFFFFEFF5

    Public Const xlLeft = &HFFFFEFDD

    Public Const xlRight = &HFFFFEFC8

    Public Const xlTop = &HFFFFEFC0

    Public Const xl3DBar = &HFFFFEFFD

    Public Const xl3DSurface = &HFFFFEFF9

    Public Const xlBar = 2

    Public Const xlColumn = 3

    Public Const xlCombination = &HFFFFEFF1

    Public Const xlCustom = &HFFFFEFEE

    Public Const xlDefaultAutoFormat = -1

    Public Const xlMaximum = 2

    Public Const xlMinimum = 4

    Public Const xlOpaque = 3

    Public Const xlTransparent = 2

    Public Const xlBidi = &HFFFFEC78

    Public Const xlLatin = &HFFFFEC77

    Public Const xlContext = &HFFFFEC76

    Public Const xlLTR = &HFFFFEC75

    Public Const xlRTL = &HFFFFEC74

    Public Const xlFullScript = 1

    Public Const xlPartialScript = 2

    Public Const xlMixedScript = 3

    Public Const xlMixedAuthorizedScript = 4

    Public Const xlVisualCursor = 2

    Public Const xlLogicalCursor = 1

    Public Const xlSystem = 1

    Public Const xlPartial = 3

    Public Const xlHindiNumerals = 3

    Public Const xlBidiCalendar = 3

    Public Const xlGregorian = 2

    Public Const xlComplete = 4

    Public Const xlScale = 3

    Public Const xlClosed = 3

    Public Const xlColor1 = 7

    Public Const xlColor2 = 8

    Public Const xlColor3 = 9

    Public Const xlConstants = 2

    Public Const xlContents = 2

    Public Const xlBelow = 1

    Public Const xlCascade = 7

    Public Const xlCenterAcrossSelection = 7

    Public Const xlChart4 = 2

    Public Const xlChartSeries = 17

    Public Const xlChartShort = 6

    Public Const xlChartTitles = 18

    Public Const xlClassic1 = 1

    Public Const xlClassic2 = 2

    Public Const xlClassic3 = 3

    Public Const xl3DEffects1 = 13

    Public Const xl3DEffects2 = 14

    Public Const xlAbove = 0

    Public Const xlAccounting1 = 4

    Public Const xlAccounting2 = 5

    Public Const xlAccounting3 = 6

    Public Const xlAccounting4 = 17

    Public Const xlAdd = 2

    Public Const xlDebugCodePane = 13

    Public Const xlDesktop = 9

    Public Const xlDirect = 1

    Public Const xlDivide = 5

    Public Const xlDoubleClosed = 5

    Public Const xlDoubleOpen = 4

    Public Const xlDoubleQuote = 1

    Public Const xlEntireChart = 20

    Public Const xlExcelMenus = 1

    Public Const xlExtended = 3

    Public Const xlFill = 5

    Public Const xlFirst = 0

    Public Const xlFloating = 5

    Public Const xlFormula = 5

    Public Const xlGeneral = 1

    Public Const xlGridline = 22

    Public Const xlIcons = 1

    Public Const xlImmediatePane = 12

    Public Const xlInteger = 2

    Public Const xlLast = 1

    Public Const xlLastCell = 11

    Public Const xlList1 = 10

    Public Const xlList2 = 11

    Public Const xlList3 = 12

    Public Const xlLocalFormat1 = 15

    Public Const xlLocalFormat2 = 16

    Public Const xlLong = 3

    Public Const xlLotusHelp = 2

    Public Const xlMacrosheetCell = 7

    Public Const xlMixed = 2

    Public Const xlMultiply = 4

    Public Const xlNarrow = 1

    Public Const xlNoDocuments = 3

    Public Const xlOpen = 2

    Public Const xlOutside = 3

    Public Const xlReference = 4

    Public Const xlSemiautomatic = 2

    Public Const xlShort = 1

    Public Const xlSingleQuote = 2

    Public Const xlStrict = 2

    Public Const xlSubtract = 3

    Public Const xlTextBox = 16

    Public Const xlTiled = 1

    Public Const xlTitleBar = 8

    Public Const xlToolbar = 1

    Public Const xlVisible = 12

    Public Const xlWatchPane = 11

    Public Const xlWide = 3

    Public Const xlWorkbookTab = 6

    Public Const xlWorksheet4 = 1

    Public Const xlWorksheetCell = 3

    Public Const xlWorksheetShort = 5

    Public Const xlAllExceptBorders = 6

    Public Const xlLeftToRight = 2

    Public Const xlTopToBottom = 1

    Public Const xlVeryHidden = 2

    Public Const xlDrawingObject = 14

    'Enum XlCreator

    Public Const xlCreatorCode = &H5843454C

    'Enum XlChartGallery

    Public Const xlBuiltIn = 21

    Public Const xlUserDefined = 22

    Public Const xlAnyGallery = 23

    'Enum XlColorIndex

    Public Const xlColorIndexAutomatic = &HFFFFEFF7

    Public Const xlColorIndexNone = &HFFFFEFD2

    'Enum XlEndStyleCap

    Public Const xlCap = 1

    Public Const xlNoCap = 2

    'Enum XlRowCol

    Public Const xlColumns = 2

    Public Const xlRows = 1

    'Enum XlScaleType

    Public Const xlScaleLinear = &HFFFFEFDC

    Public Const xlScaleLogarithmic = &HFFFFEFDB

    'Enum XlDataSeriesType

    Public Const xlAutoFill = 4

    Public Const xlChronological = 3

    Public Const xlGrowth = 2

    Public Const xlDataSeriesLinear = &HFFFFEFDC

    'Enum XlAxisCrosses

    Public Const xlAxisCrossesAutomatic = &HFFFFEFF7

    Public Const xlAxisCrossesCustom = &HFFFFEFEE

    Public Const xlAxisCrossesMaximum = 2

    Public Const xlAxisCrossesMinimum = 4

    'Enum XlAxisGroup

    Public Const xlPrimary = 1

    Public Const xlSecondary = 2

    'Enum XlBackground

    Public Const xlBackgroundAutomatic = &HFFFFEFF7

    Public Const xlBackgroundOpaque = 3

    Public Const xlBackgroundTransparent = 2

    'Enum XlWindowState

    Public Const xlMaximized = &HFFFFEFD7

    Public Const xlMinimized = &HFFFFEFD4

    Public Const xlNormal = &HFFFFEFD1

    'Enum XlAxisType

    Public Const xlCategory = 1

    Public Const xlSeriesAxis = 3

    Public Const xlValue = 2

    'Enum XlArrowHeadLength

    Public Const xlArrowHeadLengthLong = 3

    Public Const xlArrowHeadLengthMedium = &HFFFFEFD6

    Public Const xlArrowHeadLengthShort = 1

    'Enum XlVAlign

    Public Const xlVAlignBottom = &HFFFFEFF5

    Public Const xlVAlignCenter = &HFFFFEFF4

    Public Const xlVAlignDistributed = &HFFFFEFEB

    Public Const xlVAlignJustify = &HFFFFEFDE

    Public Const xlVAlignTop = &HFFFFEFC0

    'Enum XlTickMark

    Public Const xlTickMarkCross = 4

    Public Const xlTickMarkInside = 2

    Public Const xlTickMarkNone = &HFFFFEFD2

    Public Const xlTickMarkOutside = 3

    'Enum XlErrorBarDirection

    Public Const xlX = &HFFFFEFB8

    Public Const xlY = 1

    'Enum XlErrorBarInclude

    Public Const xlErrorBarIncludeBoth = 1

    Public Const xlErrorBarIncludeMinusValues = 3

    Public Const xlErrorBarIncludeNone = &HFFFFEFD2

    Public Const xlErrorBarIncludePlusValues = 2

    'Enum XlDisplayBlanksAs

    Public Const xlInterpolated = 3

    Public Const xlNotPlotted = 1

    Public Const xlZero = 2

    'Enum XlArrowHeadStyle

    Public Const xlArrowHeadStyleClosed = 3

    Public Const xlArrowHeadStyleDoubleClosed = 5

    Public Const xlArrowHeadStyleDoubleOpen = 4

    Public Const xlArrowHeadStyleNone = &HFFFFEFD2

    Public Const xlArrowHeadStyleOpen = 2

    'Enum XlArrowHeadWidth

    Public Const xlArrowHeadWidthMedium = &HFFFFEFD6

    Public Const xlArrowHeadWidthNarrow = 1

    Public Const xlArrowHeadWidthWide = 3

    'Enum XlHAlign

    Public Const xlHAlignCenter = &HFFFFEFF4

    Public Const xlHAlignCenterAcrossSelection = 7

    Public Const xlHAlignDistributed = &HFFFFEFEB

    Public Const xlHAlignFill = 5

    Public Const xlHAlignGeneral = 1

    Public Const xlHAlignJustify = &HFFFFEFDE

    Public Const xlHAlignLeft = &HFFFFEFDD

    Public Const xlHAlignRight = &HFFFFEFC8

    'Enum XlTickLabelPosition

    Public Const xlTickLabelPositionHigh = &HFFFFEFE1

    Public Const xlTickLabelPositionLow = &HFFFFEFDA

    Public Const xlTickLabelPositionNextToAxis = 4

    Public Const xlTickLabelPositionNone = &HFFFFEFD2

    'Enum XlLegendPosition

    Public Const xlLegendPositionBottom = &HFFFFEFF5

    Public Const xlLegendPositionCorner = 2

    Public Const xlLegendPositionLeft = &HFFFFEFDD

    Public Const xlLegendPositionRight = &HFFFFEFC8

    Public Const xlLegendPositionTop = &HFFFFEFC0

    'Enum XlChartPictureType

    Public Const xlStackScale = 3

    Public Const xlStack = 2

    Public Const xlStretch = 1

    'Enum XlChartPicturePlacement

    Public Const xlSides = 1

    Public Const xlEnd = 2

    Public Const xlEndSides = 3

    Public Const xlFront = 4

    Public Const xlFrontSides = 5

    Public Const xlFrontEnd = 6

    Public Const xlAllFaces = 7

    'Enum XlOrientation

    Public Const xlDownward = &HFFFFEFB6

    Public Const xlHorizontal = &HFFFFEFE0

    Public Const xlUpward = &HFFFFEFB5

    Public Const xlVertical = &HFFFFEFBA

    'Enum XlTickLabelOrientation

    Public Const xlTickLabelOrientationAutomatic = &HFFFFEFF7

    Public Const xlTickLabelOrientationDownward = &HFFFFEFB6

    Public Const xlTickLabelOrientationHorizontal = &HFFFFEFE0

    Public Const xlTickLabelOrientationUpward = &HFFFFEFB5

    Public Const xlTickLabelOrientationVertical = &HFFFFEFBA

    'Enum XlBorderWeight

    Public Const xlHairline = 1

    Public Const xlMedium = &HFFFFEFD6

    Public Const xlThick = 4

    Public Const xlThin = 2

    'Enum XlDataSeriesDate

    Public Const xlDay = 1

    Public Const xlMonth = 3

    Public Const xlWeekday = 2

    Public Const xlYear = 4

    'Enum XlUnderlineStyle

    Public Const xlUnderlineStyleDouble = &HFFFFEFE9

    Public Const xlUnderlineStyleDoubleAccounting = 5

    Public Const xlUnderlineStyleNone = &HFFFFEFD2

    Public Const xlUnderlineStyleSingle = 2

    Public Const xlUnderlineStyleSingleAccounting = 4

    'Enum XlErrorBarType

    Public Const xlErrorBarTypeCustom = &HFFFFEFEE

    Public Const xlErrorBarTypeFixedValue = 1

    Public Const xlErrorBarTypePercent = 2

    Public Const xlErrorBarTypeStDev = &HFFFFEFC5

    Public Const xlErrorBarTypeStError = 4

    'Enum XlTrendlineType

    Public Const xlExponential = 5

    Public Const xlLinear = &HFFFFEFDC

    Public Const xlLogarithmic = &HFFFFEFDB

    Public Const xlMovingAvg = 6

    Public Const xlPolynomial = 3

    Public Const xlPower = 4

    'Enum XlLineStyle

    Public Const xlContinuous = 1

    Public Const xlDash = &HFFFFEFED

    Public Const xlDashDot = 4

    Public Const xlDashDotDot = 5

    Public Const xlDot = &HFFFFEFEA

    Public Const xlDouble = &HFFFFEFE9

    Public Const xlSlantDashDot = 13

    Public Const xlLineStyleNone = &HFFFFEFD2

    'Enum XlDataLabelsType

    Public Const xlDataLabelsShowNone = &HFFFFEFD2

    Public Const xlDataLabelsShowValue = 2

    Public Const xlDataLabelsShowPercent = 3

    Public Const xlDataLabelsShowLabel = 4

    Public Const xlDataLabelsShowLabelAndPercent = 5

    Public Const xlDataLabelsShowBubbleSizes = 6

    'Enum XlMarkerStyle

    Public Const xlMarkerStyleAutomatic = &HFFFFEFF7

    Public Const xlMarkerStyleCircle = 8

    Public Const xlMarkerStyleDash = &HFFFFEFED

    Public Const xlMarkerStyleDiamond = 2

    Public Const xlMarkerStyleDot = &HFFFFEFEA

    Public Const xlMarkerStyleNone = &HFFFFEFD2

    Public Const xlMarkerStylePicture = &HFFFFEFCD

    Public Const xlMarkerStylePlus = 9

    Public Const xlMarkerStyleSquare = 1

    Public Const xlMarkerStyleStar = 5

    Public Const xlMarkerStyleTriangle = 3

    Public Const xlMarkerStyleX = &HFFFFEFB8

    'Enum XlPictureConvertorType

    Public Const xlBMP = 1

    Public Const xlCGM = 7

    Public Const xlDRW = 4

    Public Const xlDXF = 5

    Public Const xlEPS = 8

    Public Const xlHGL = 6

    Public Const xlPCT = 13

    Public Const xlPCX = 10

    Public Const xlPIC = 11

    Public Const xlPLT = 12

    Public Const xlTIF = 9

    Public Const xlWMF = 2

    Public Const xlWPG = 3

    'Enum XlPattern

    Public Const xlPatternAutomatic = &HFFFFEFF7

    Public Const xlPatternChecker = 9

    Public Const xlPatternCrissCross = 16

    Public Const xlPatternDown = &HFFFFEFE7

    Public Const xlPatternGray16 = 17

    Public Const xlPatternGray25 = &HFFFFEFE4

    Public Const xlPatternGray50 = &HFFFFEFE3

    Public Const xlPatternGray75 = &HFFFFEFE2

    Public Const xlPatternGray8 = 18

    Public Const xlPatternGrid = 15

    Public Const xlPatternHorizontal = &HFFFFEFE0

    Public Const xlPatternLightDown = 13

    Public Const xlPatternLightHorizontal = 11

    Public Const xlPatternLightUp = 14

    Public Const xlPatternLightVertical = 12

    Public Const xlPatternNone = &HFFFFEFD2

    Public Const xlPatternSemiGray75 = 10

    Public Const xlPatternSolid = 1

    Public Const xlPatternUp = &HFFFFEFBE

    Public Const xlPatternVertical = &HFFFFEFBA

    'Enum XlChartSplitType

    Public Const xlSplitByPosition = 1

    Public Const xlSplitByPercentValue = 3

    Public Const xlSplitByCustomSplit = 4

    Public Const xlSplitByValue = 2

    'Enum XlDisplayUnit

    Public Const xlHundreds = -2

    Public Const xlThousands = -3

    Public Const xlTenThousands = -4

    Public Const xlHundredThousands = -5

    Public Const xlMillions = -6

    Public Const xlTenMillions = -7

    Public Const xlHundredMillions = -8

    Public Const xlThousandMillions = -9

    Public Const xlMillionMillions = -10

    'Enum XlDataLabelPosition

    Public Const xlLabelPositionCenter = &HFFFFEFF4

    Public Const xlLabelPositionAbove = 0

    Public Const xlLabelPositionBelow = 1

    Public Const xlLabelPositionLeft = &HFFFFEFDD

    Public Const xlLabelPositionRight = &HFFFFEFC8

    Public Const xlLabelPositionOutsideEnd = 2

    Public Const xlLabelPositionInsideEnd = 3

    Public Const xlLabelPositionInsideBase = 4

    Public Const xlLabelPositionBestFit = 5

    Public Const xlLabelPositionMixed = 6

    Public Const xlLabelPositionCustom = 7

    'Enum XlTimeUnit

    Public Const xlDays = 0

    Public Const xlMonths = 1

    Public Const xlYears = 2

    'Enum XlCategoryType

    Public Const xlCategoryScale = 2

    Public Const xlTimeScale = 3

    Public Const xlAutomaticScale = &HFFFFEFF7

    'Enum XlBarShape

    Public Const xlBox = 0

    Public Const xlPyramidToPoint = 1

    Public Const xlPyramidToMax = 2

    Public Const xlCylinder = 3

    Public Const xlConeToPoint = 4

    Public Const xlConeToMax = 5

    'Enum XlChartType

    Public Const xlColumnClustered = 51

    Public Const xlColumnStacked = 52

    Public Const xlColumnStacked100 = 53

    Public Const xl3DColumnClustered = 54

    Public Const xl3DColumnStacked = 55

    Public Const xl3DColumnStacked100 = 56

    Public Const xlBarClustered = 57

    Public Const xlBarStacked = 58

    Public Const xlBarStacked100 = 59

    Public Const xl3DBarClustered = 60

    Public Const xl3DBarStacked = 61

    Public Const xl3DBarStacked100 = 62

    Public Const xlLineStacked = 63

    Public Const xlLineStacked100 = 64

    Public Const xlLineMarkers = 65

    Public Const xlLineMarkersStacked = 66

    Public Const xlLineMarkersStacked100 = 67

    Public Const xlPieOfPie = 68

    Public Const xlPieExploded = 69

    Public Const xl3DPieExploded = 70

    Public Const xlBarOfPie = 71

    Public Const xlXYScatterSmooth = 72

    Public Const xlXYScatterSmoothNoMarkers = 73

    Public Const xlXYScatterLines = 74

    Public Const xlXYScatterLinesNoMarkers = 75

    Public Const xlAreaStacked = 76

    Public Const xlAreaStacked100 = 77

    Public Const xl3DAreaStacked = 78

    Public Const xl3DAreaStacked100 = 79

    Public Const xlDoughnutExploded = 80

    Public Const xlRadarMarkers = 81

    Public Const xlRadarFilled = 82

    Public Const xlSurface = 83

    Public Const xlSurfaceWireframe = 84

    Public Const xlSurfaceTopView = 85

    Public Const xlSurfaceTopViewWireframe = 86

    Public Const xlBubble = 15

    Public Const xlBubble3DEffect = 87

    Public Const xlStockHLC = 88

    Public Const xlStockOHLC = 89

    Public Const xlStockVHLC = 90

    Public Const xlStockVOHLC = 91

    Public Const xlCylinderColClustered = 92

    Public Const xlCylinderColStacked = 93

    Public Const xlCylinderColStacked100 = 94

    Public Const xlCylinderBarClustered = 95

    Public Const xlCylinderBarStacked = 96

    Public Const xlCylinderBarStacked100 = 97

    Public Const xlCylinderCol = 98

    Public Const xlConeColClustered = 99

    Public Const xlConeColStacked = 100

    Public Const xlConeColStacked100 = 101

    Public Const xlConeBarClustered = 102

    Public Const xlConeBarStacked = 103

    Public Const xlConeBarStacked100 = 104

    Public Const xlConeCol = 105

    Public Const xlPyramidColClustered = 106

    Public Const xlPyramidColStacked = 107

    Public Const xlPyramidColStacked100 = 108

    Public Const xlPyramidBarClustered = 109

    Public Const xlPyramidBarStacked = 110

    Public Const xlPyramidBarStacked100 = 111

    Public Const xlPyramidCol = 112

    Public Const xl3DColumn = &HFFFFEFFC

    Public Const xlLine = 4

    Public Const xl3DLine = &HFFFFEFFB

    Public Const xl3DPie = &HFFFFEFFA

    Public Const xlPie = 5

    Public Const xlXYScatter = &HFFFFEFB7

    Public Const xl3DArea = &HFFFFEFFE

    Public Const xlArea = 1

    Public Const xlDoughnut = &HFFFFEFE8

    Public Const xlRadar = &HFFFFEFC9

    'Enum XlChartItem

    Public Const xlDataLabel = 0

    Public Const xlChartArea = 2

    Public Const xlSeries = 3

    Public Const xlChartTitle = 4

    Public Const xlWalls = 5

    Public Const xlCorners = 6

    Public Const xlDataTable = 7

    Public Const xlTrendline = 8

    Public Const xlErrorBars = 9

    Public Const xlXErrorBars = 10

    Public Const xlYErrorBars = 11

    Public Const xlLegendEntry = 12

    Public Const xlLegendKey = 13

    Public Const xlShape = 14

    Public Const xlMajorGridlines = 15

    Public Const xlMinorGridlines = 16

    Public Const xlAxisTitle = 17

    Public Const xlUpBars = 18

    Public Const xlPlotArea = 19

    Public Const xlDownBars = 20

    Public Const xlAxis = 21

    Public Const xlSeriesLines = 22

    Public Const xlFloor = 23

    Public Const xlLegend = 24

    Public Const xlHiLoLines = 25

    Public Const xlDropLines = 26

    Public Const xlRadarAxisLabels = 27

    Public Const xlNothing = 28

    Public Const xlLeaderLines = 29

    Public Const xlDisplayUnitLabel = 30

    Public Const xlPivotChartFieldButton = 31

    Public Const xlPivotChartDropZone = 32

    'Enum XlSizeRepresents

    Public Const xlSizeIsWidth = 2

    Public Const xlSizeIsArea = 1

    'Enum XlInsertShiftDirection

    Public Const xlShiftDown = &HFFFFEFE7

    Public Const xlShiftToRight = &HFFFFEFBF

    'Enum XlDeleteShiftDirection

    Public Const xlShiftToLeft = &HFFFFEFC1

    Public Const xlShiftUp = &HFFFFEFBE

    'Enum XlDirection

    Public Const xlDown = &HFFFFEFE7

    Public Const xlToLeft = &HFFFFEFC1

    Public Const xlToRight = &HFFFFEFBF

    Public Const xlUp = &HFFFFEFBE

    'Enum XlConsolidationFunction

    Public Const xlAverage = &HFFFFEFF6

    Public Const xlCount = &HFFFFEFF0

    Public Const xlCountNums = &HFFFFEFEF

    Public Const xlMax = &HFFFFEFD8

    Public Const xlMin = &HFFFFEFD5

    Public Const xlProduct = &HFFFFEFCB

    Public Const xlStDev = &HFFFFEFC5

    Public Const xlStDevP = &HFFFFEFC4

    Public Const xlSum = &HFFFFEFC3

    Public Const xlVar = &HFFFFEFBC

    Public Const xlVarP = &HFFFFEFBB

    Public Const xlUnknown = &H3E8

    'Enum XlSheetType

    Public Const xlChart = &HFFFFEFF3

    Public Const xlDialogSheet = &HFFFFEFEC

    Public Const xlExcel4IntlMacroSheet = 4

    Public Const xlExcel4MacroSheet = 3

    Public Const xlWorksheet = &HFFFFEFB9

    'Enum XlLocationInTable

    Public Const xlColumnHeader = &HFFFFEFF2

    Public Const xlColumnItem = 5

    Public Const xlDataHeader = 3

    Public Const xlDataItem = 7

    Public Const xlPageHeader = 2

    Public Const xlPageItem = 6

    Public Const xlRowHeader = &HFFFFEFC7

    Public Const xlRowItem = 4

    Public Const xlTableBody = 8

    'Enum XlFindLookIn

    Public Const xlFormulas = &HFFFFEFE5

    Public Const xlComments = &HFFFFEFD0

    Public Const xlValues = &HFFFFEFBD

    'Enum XlWindowType

    Public Const xlChartAsWindow = 5

    Public Const xlChartInPlace = 4

    Public Const xlClipboard = 3

    Public Const xlInfo = &HFFFFEFDF

    Public Const xlWorkbook = 1

    'Enum XlPivotFieldDataType

    Public Const xlDate = 2

    Public Const xlNumber = &HFFFFEFCF

    Public Const xlText = &HFFFFEFC2

    'Enum XlCopyPictureFormat

    Public Const xlBitmap = 2

    Public Const xlPicture = &HFFFFEFCD

    'Enum XlPivotTableSourceType

    Public Const xlConsolidation = 3

    Public Const xlDatabase = 1

    Public Const xlExternal = 2

    Public Const xlPivotTable = &HFFFFEFCC

    'Enum XlReferenceStyle

    Public Const xlA1 = 1

    Public Const xlR1C1 = &HFFFFEFCA

    'Enum XlMSApplication

    Public Const xlMicrosoftAccess = 4

    Public Const xlMicrosoftFoxPro = 5

    Public Const xlMicrosoftMail = 3

    Public Const xlMicrosoftPowerPoint = 2

    Public Const xlMicrosoftProject = 6

    Public Const xlMicrosoftSchedulePlus = 7

    Public Const xlMicrosoftWord = 1

    'Enum XlMouseButton

    Public Const xlNoButton = 0

    Public Const xlPrimaryButton = 1

    Public Const xlSecondaryButton = 2

    'Enum XlCutCopyMode

    Public Const xlCopy = 1

    Public Const xlCut = 2

    'Enum XlFillWith

    Public Const xlFillWithAll = &HFFFFEFF8

    Public Const xlFillWithContents = 2

    Public Const xlFillWithFormats = &HFFFFEFE6

    'Enum XlFilterAction

    Public Const xlFilterCopy = 2

    Public Const xlFilterInPlace = 1

    'Enum XlOrder

    Public Const xlDownThenOver = 1

    Public Const xlOverThenDown = 2

    'Enum XlLinkType

    Public Const xlLinkTypeExcelLinks = 1

    Public Const xlLinkTypeOLELinks = 2

    'Enum XlApplyNamesOrder

    Public Const xlColumnThenRow = 2

    Public Const xlRowThenColumn = 1

    'Enum XlEnableCancelKey

    Public Const xlDisabled = 0

    Public Const xlErrorHandler = 2

    Public Const xlInterrupt = 1

    'Enum XlPageBreak

    Public Const xlPageBreakAutomatic = &HFFFFEFF7

    Public Const xlPageBreakManual = &HFFFFEFD9

    Public Const xlPageBreakNone = &HFFFFEFD2

    'Enum XlOLEType

    Public Const xlOLEControl = 2

    Public Const xlOLEEmbed = 1

    Public Const xlOLELink = 0

    'Enum XlPageOrientation

    Public Const xlLandscape = 2

    Public Const xlPortrait = 1

    'Enum XlLinkInfo

    Public Const xlEditionDate = 2

    Public Const xlUpdateState = 1

    'Enum XlCommandUnderlines

    Public Const xlCommandUnderlinesAutomatic = &HFFFFEFF7

    Public Const xlCommandUnderlinesOff = &HFFFFEFCE

    Public Const xlCommandUnderlinesOn = 1

    'Enum XlOLEVerb

    Public Const xlVerbOpen = 2

    Public Const xlVerbPrimary = 1

    'Enum XlCalculation

    Public Const xlCalculationAutomatic = &HFFFFEFF7

    Public Const xlCalculationManual = &HFFFFEFD9

    Public Const xlCalculationSemiautomatic = 2

    'Enum XlFileAccess

    Public Const xlReadOnly = 3

    Public Const xlReadWrite = 2

    'Enum XlEditionType

    Public Const xlPublisher = 1

    Public Const xlSubscriber = 2

    'Enum XlObjectSize

    Public Const xlFitToPage = 2

    Public Const xlFullPage = 3

    Public Const xlScreenSize = 1

    'Enum XlLookAt

    Public Const xlPart = 2

    Public Const xlWhole = 1

    'Enum XlMailSystem

    Public Const xlMAPI = 1

    Public Const xlNoMailSystem = 0

    Public Const xlPowerTalk = 2

    'Enum XlLinkInfoType

    Public Const xlLinkInfoOLELinks = 2

    Public Const xlLinkInfoPublishers = 5

    Public Const xlLinkInfoSubscribers = 6

    'Enum XlCVError

    Public Const xlErrDiv0 = &H7D7

    Public Const xlErrNA = &H7FA

    Public Const xlErrName = &H7ED

    Public Const xlErrNull = &H7D0

    Public Const xlErrNum = &H7F4

    Public Const xlErrRef = &H7E7

    Public Const xlErrValue = &H7DF

    'Enum XlEditionFormat

    Public Const xlBIFF = 2

    Public Const xlPICT = 1

    Public Const xlRTF = 4

    Public Const xlVALU = 8

    'Enum XlLink

    Public Const xlExcelLinks = 1

    Public Const xlOLELinks = 2

    Public Const xlPublishers = 5

    Public Const xlSubscribers = 6

    'Enum XlCellType

    Public Const xlCellTypeBlanks = 4

    Public Const xlCellTypeConstants = 2

    Public Const xlCellTypeFormulas = &HFFFFEFE5

    Public Const xlCellTypeLastCell = 11

    Public Const xlCellTypeComments = &HFFFFEFD0

    Public Const xlCellTypeVisible = 12

    Public Const xlCellTypeAllFormatConditions = &HFFFFEFB4

    Public Const xlCellTypeSameFormatConditions = &HFFFFEFB3

    Public Const xlCellTypeAllValidation = &HFFFFEFB2

    Public Const xlCellTypeSameValidation = &HFFFFEFB1

    'Enum XlArrangeStyle

    Public Const xlArrangeStyleCascade = 7

    Public Const xlArrangeStyleHorizontal = &HFFFFEFE0

    Public Const xlArrangeStyleTiled = 1

    Public Const xlArrangeStyleVertical = &HFFFFEFBA

    'Enum XlMousePointer

    Public Const xlIBeam = 3

    Public Const xlDefault = &HFFFFEFD1

    Public Const xlNorthwestArrow = 1

    Public Const xlWait = 2

    'Enum XlEditionOptionsOption

    Public Const xlAutomaticUpdate = 4

    Public Const xlCancel = 1

    Public Const xlChangeAttributes = 6

    Public Const xlManualUpdate = 5

    Public Const xlOpenSource = 3

    Public Const xlSelect = 3

    Public Const xlSendPublisher = 2

    Public Const xlUpdateSubscriber = 2

    'Enum XlAutoFillType

    Public Const xlFillCopy = 1

    Public Const xlFillDays = 5

    Public Const xlFillDefault = 0

    Public Const xlFillFormats = 3

    Public Const xlFillMonths = 7

    Public Const xlFillSeries = 2

    Public Const xlFillValues = 4

    Public Const xlFillWeekdays = 6

    Public Const xlFillYears = 8

    Public Const xlGrowthTrend = 10

    Public Const xlLinearTrend = 9

    'Enum XlAutoFilterOperator

    Public Const xlAnd = 1

    Public Const xlBottom10Items = 4

    Public Const xlBottom10Percent = 6

    Public Const xlOr = 2

    Public Const xlTop10Items = 3

    Public Const xlTop10Percent = 5

    'Enum XlClipboardFormat

    Public Const xlClipboardFormatBIFF = 8

    Public Const xlClipboardFormatBIFF2 = 18

    Public Const xlClipboardFormatBIFF3 = 20

    Public Const xlClipboardFormatBIFF4 = 30

    Public Const xlClipboardFormatBinary = 15

    Public Const xlClipboardFormatBitmap = 9

    Public Const xlClipboardFormatCGM = 13

    Public Const xlClipboardFormatCSV = 5

    Public Const xlClipboardFormatDIF = 4

    Public Const xlClipboardFormatDspText = 12

    Public Const xlClipboardFormatEmbeddedObject = 21

    Public Const xlClipboardFormatEmbedSource = 22

    Public Const xlClipboardFormatLink = 11

    Public Const xlClipboardFormatLinkSource = 23

    Public Const xlClipboardFormatLinkSourceDesc = 32

    Public Const xlClipboardFormatMovie = 24

    Public Const xlClipboardFormatNative = 14

    Public Const xlClipboardFormatObjectDesc = 31

    Public Const xlClipboardFormatObjectLink = 19

    Public Const xlClipboardFormatOwnerLink = 17

    Public Const xlClipboardFormatPICT = 2

    Public Const xlClipboardFormatPrintPICT = 3

    Public Const xlClipboardFormatRTF = 7

    Public Const xlClipboardFormatScreenPICT = 29

    Public Const xlClipboardFormatStandardFont = 28

    Public Const xlClipboardFormatStandardScale = 27

    Public Const xlClipboardFormatSYLK = 6

    Public Const xlClipboardFormatTable = 16

    Public Const xlClipboardFormatText = 0

    Public Const xlClipboardFormatToolFace = 25

    Public Const xlClipboardFormatToolFacePICT = 26

    Public Const xlClipboardFormatVALU = 1

    Public Const xlClipboardFormatWK1 = 10

    'Enum XlFileFormat

    Public Const xlAddIn = 18

    Public Const xlCSV = 6

    Public Const xlCSVMac = 22

    Public Const xlCSVMSDOS = 24

    Public Const xlCSVWindows = 23

    Public Const xlDBF2 = 7

    Public Const xlDBF3 = 8

    Public Const xlDBF4 = 11

    Public Const xlDIF = 9

    Public Const xlExcel2 = 16

    Public Const xlExcel2FarEast = 27

    Public Const xlExcel3 = 29

    Public Const xlExcel4 = 33

    Public Const xlExcel5 = 39

    Public Const xlExcel7 = 39

    Public Const xlExcel9795 = 43

    Public Const xlExcel4Workbook = 35

    Public Const xlIntlAddIn = 26

    Public Const xlIntlMacro = 25

    Public Const xlWorkbookNormal = &HFFFFEFD1

    Public Const xlSYLK = 2

    Public Const xlTemplate = 17

    Public Const xlCurrentPlatformText = &HFFFFEFC2

    Public Const xlTextMac = 19

    Public Const xlTextMSDOS = 21

    Public Const xlTextPrinter = 36

    Public Const xlTextWindows = 20

    Public Const xlWJ2WD1 = 14

    Public Const xlWK1 = 5

    Public Const xlWK1ALL = 31

    Public Const xlWK1FMT = 30

    Public Const xlWK3 = 15

    Public Const xlWK4 = 38

    Public Const xlWK3FM3 = 32

    Public Const xlWKS = 4

    Public Const xlWorks2FarEast = 28

    Public Const xlWQ1 = 34

    Public Const xlWJ3 = 40

    Public Const xlWJ3FJ3 = 41

    Public Const xlUnicodeText = 42

    Public Const xlHtml = 44

    'Enum XlApplicationInternational

    Public Const xl24HourClock = 33

    Public Const xl4DigitYears = 43

    Public Const xlAlternateArraySeparator = 16

    Public Const xlColumnSeparator = 14

    Public Const xlCountryCode = 1

    Public Const xlCountrySetting = 2

    Public Const xlCurrencyBefore = 37

    Public Const xlCurrencyCode = 25

    Public Const xlCurrencyDigits = 27

    Public Const xlCurrencyLeadingZeros = 40

    Public Const xlCurrencyMinusSign = 38

    Public Const xlCurrencyNegative = 28

    Public Const xlCurrencySpaceBefore = 36

    Public Const xlCurrencyTrailingZeros = 39

    Public Const xlDateOrder = 32

    Public Const xlDateSeparator = 17

    Public Const xlDayCode = 21

    Public Const xlDayLeadingZero = 42

    Public Const xlDecimalSeparator = 3

    Public Const xlGeneralFormatName = 26

    Public Const xlHourCode = 22

    Public Const xlLeftBrace = 12

    Public Const xlLeftBracket = 10

    Public Const xlListSeparator = 5

    Public Const xlLowerCaseColumnLetter = 9

    Public Const xlLowerCaseRowLetter = 8

    Public Const xlMDY = 44

    Public Const xlMetric = 35

    Public Const xlMinuteCode = 23

    Public Const xlMonthCode = 20

    Public Const xlMonthLeadingZero = 41

    Public Const xlMonthNameChars = 30

    Public Const xlNoncurrencyDigits = 29

    Public Const xlNonEnglishFunctions = 34

    Public Const xlRightBrace = 13

    Public Const xlRightBracket = 11

    Public Const xlRowSeparator = 15

    Public Const xlSecondCode = 24

    Public Const xlThousandsSeparator = 4

    Public Const xlTimeLeadingZero = 45

    Public Const xlTimeSeparator = 18

    Public Const xlUpperCaseColumnLetter = 7

    Public Const xlUpperCaseRowLetter = 6

    Public Const xlWeekdayNameChars = 31

    Public Const xlYearCode = 19

    'Enum XlPageBreakExtent

    Public Const xlPageBreakFull = 1

    Public Const xlPageBreakPartial = 2

    'Enum XlCellInsertionMode

    Public Const xlOverwriteCells = 0

    Public Const xlInsertDeleteCells = 1

    Public Const xlInsertEntireRows = 2

    'Enum XlFormulaLabel

    Public Const xlNoLabels = &HFFFFEFD2

    Public Const xlRowLabels = 1

    Public Const xlColumnLabels = 2

    Public Const xlMixedLabels = 3

    'Enum XlHighlightChangesTime

    Public Const xlSinceMyLastSave = 1

    Public Const xlAllChanges = 2

    Public Const xlNotYetReviewed = 3

    'Enum XlCommentDisplayMode

    Public Const xlNoIndicator = 0

    Public Const xlCommentIndicatorOnly = -1

    Public Const xlCommentAndIndicator = 1

    'Enum XlFormatConditionType

    Public Const xlCellValue = 1

    Public Const xlExpression = 2

    'Enum XlFormatConditionOperator

    Public Const xlBetween = 1

    Public Const xlNotBetween = 2

    Public Const xlEqual = 3

    Public Const xlNotEqual = 4

    Public Const xlGreater = 5

    Public Const xlLess = 6

    Public Const xlGreaterEqual = 7

    Public Const xlLessEqual = 8

    'Enum XlEnableSelection

    Public Const xlNoRestrictions = 0

    Public Const xlUnlockedCells = 1

    Public Const xlNoSelection = &HFFFFEFD2

    'Enum XlDVType

    Public Const xlValidateInputOnly = 0

    Public Const xlValidateWholEnumber = 1

    Public Const xlValidateDecimal = 2

    Public Const xlValidateList = 3

    Public Const xlValidateDate = 4

    Public Const xlValidateTime = 5

    Public Const xlValidateTextLength = 6

    Public Const xlValidateCustom = 7

    'Enum XlIMEMode

    Public Const xlIMEModeNoControl = 0

    Public Const xlIMEModeOn = 1

    Public Const xlIMEModeOff = 2

    Public Const xlIMEModeDisable = 3

    Public Const xlIMEModeHiragana = 4

    Public Const xlIMEModeKatakana = 5

    Public Const xlIMEModeKatakanaHalf = 6

    Public Const xlIMEModeAlphaFull = 7

    Public Const xlIMEModeAlpha = 8

    Public Const xlIMEModeHangulFull = 9

    Public Const xlIMEModeHangul = 10

    'Enum XlDVAlertStyle

    Public Const xlValidAlertStop = 1

    Public Const xlValidAlertWarning = 2

    Public Const xlValidAlertInformation = 3

    'Enum XlChartLocation

    Public Const xlLocationAsNewSheet = 1

    Public Const xlLocationAsObject = 2

    Public Const xlLocationAutomatic = 3

    'Enum XlPaperSize

    Public Const xlPaper10x14 = 16

    Public Const xlPaper11x17 = 17

    Public Const xlPaperA3 = 8

    Public Const xlPaperA4 = 9

    Public Const xlPaperA4Small = 10

    Public Const xlPaperA5 = 11

    Public Const xlPaperB4 = 12

    Public Const xlPaperB5 = 13

    Public Const xlPaperCsheet = 24

    Public Const xlPaperDsheet = 25

    Public Const xlPaperEnvelope10 = 20

    Public Const xlPaperEnvelope11 = 21

    Public Const xlPaperEnvelope12 = 22

    Public Const xlPaperEnvelope14 = 23

    Public Const xlPaperEnvelope9 = 19

    Public Const xlPaperEnvelopeB4 = 33

    Public Const xlPaperEnvelopeB5 = 34

    Public Const xlPaperEnvelopeB6 = 35

    Public Const xlPaperEnvelopeC3 = 29

    Public Const xlPaperEnvelopeC4 = 30

    Public Const xlPaperEnvelopeC5 = 28

    Public Const xlPaperEnvelopeC6 = 31

    Public Const xlPaperEnvelopeC65 = 32

    Public Const xlPaperEnvelopeDL = 27

    Public Const xlPaperEnvelopeItaly = 36

    Public Const xlPaperEnvelopeMonarch = 37

    Public Const xlPaperEnvelopePersonal = 38

    Public Const xlPaperEsheet = 26

    Public Const xlPaperExecutive = 7

    Public Const xlPaperFanfoldLegalGerman = 41

    Public Const xlPaperFanfoldStdGerman = 40

    Public Const xlPaperFanfoldUS = 39

    Public Const xlPaperFolio = 14

    Public Const xlPaperLedger = 4

    Public Const xlPaperLegal = 5

    Public Const xlPaperLetter = 1

    Public Const xlPaperLetterSmall = 2

    Public Const xlPaperNote = 18

    Public Const xlPaperQuarto = 15

    Public Const xlPaperStatement = 6

    Public Const xlPaperTabloid = 3

    Public Const xlPaperUser = &H100

    'Enum XlPasteSpecialOperation

    Public Const xlPasteSpecialOperationAdd = 2

    Public Const xlPasteSpecialOperationDivide = 5

    Public Const xlPasteSpecialOperationMultiply = 4

    Public Const xlPasteSpecialOperationNone = &HFFFFEFD2

    Public Const xlPasteSpecialOperationSubtract = 3

    'Enum XlPasteType

    Public Const xlPasteAll = &HFFFFEFF8

    Public Const xlPasteAllExceptBorders = 7

    Public Const xlPasteFormats = &HFFFFEFE6

    Public Const xlPasteFormulas = &HFFFFEFE5

    Public Const xlPasteComments = &HFFFFEFD0

    Public Const xlPasteValues = &HFFFFEFBD

    'Enum XlPhoneticCharacterType

    Public Const xlKatakanaHalf = 0

    Public Const xlKatakana = 1

    Public Const xlHiragana = 2

    Public Const xlNoConversion = 3

    'Enum XlPhoneticAlignment

    Public Const xlPhoneticAlignNoControl = 0

    Public Const xlPhoneticAlignLeft = 1

    Public Const xlPhoneticAlignCenter = 2

    Public Const xlPhoneticAlignDistributed = 3

    'Enum XlPictureAppearance

    Public Const xlPrinter = 2

    Public Const xlScreen = 1

    'Enum XlPivotFieldOrientation

    Public Const xlColumnField = 2

    Public Const xlDataField = 4

    Public Const xlHidden = 0

    Public Const xlPageField = 3

    Public Const xlRowField = 1

    'Enum XlPivotFieldCalculation

    Public Const xlDifferenceFrom = 2

    Public Const xlIndex = 9

    Public Const xlNoAdditionalCalculation = &HFFFFEFD1

    Public Const xlPercentDifferenceFrom = 4

    Public Const xlPercentOf = 3

    Public Const xlPercentOfColumn = 7

    Public Const xlPercentOfRow = 6

    Public Const xlPercentOfTotal = 8

    Public Const xlRunningTotal = 5

    'Enum XlPlacement

    Public Const xlFreeFloating = 3

    Public Const xlMove = 2

    Public Const xlMoveAndSize = 1

    'Enum XlPlatform

    Public Const xlMacintosh = 1

    Public Const xlMSDOS = 3

    Public Const xlWindows = 2

    'Enum XlPrintLocation

    Public Const xlPrintSheetEnd = 1

    Public Const xlPrintInPlace = 16

    Public Const xlPrintNoComments = &HFFFFEFD2

    'Enum XlPriority

    Public Const xlPriorityHigh = &HFFFFEFE1

    Public Const xlPriorityLow = &HFFFFEFDA

    Public Const xlPriorityNormal = &HFFFFEFD1

    'Enum XlPTSelectionMode

    Public Const xlLabelOnly = 1

    Public Const xlDataAndLabel = 0

    Public Const xlDataOnly = 2

    Public Const xlOrigin = 3

    Public Const xlButton = 15

    Public Const xlBlanks = 4

    Public Const xlFirstRow = &H100

    'Enum XlRangeAutoFormat

    Public Const xlRangeAutoFormat3DEffects1 = 13

    Public Const xlRangeAutoFormat3DEffects2 = 14

    Public Const xlRangeAutoFormatAccounting1 = 4

    Public Const xlRangeAutoFormatAccounting2 = 5

    Public Const xlRangeAutoFormatAccounting3 = 6

    Public Const xlRangeAutoFormatAccounting4 = 17

    Public Const xlRangeAutoFormatClassic1 = 1

    Public Const xlRangeAutoFormatClassic2 = 2

    Public Const xlRangeAutoFormatClassic3 = 3

    Public Const xlRangeAutoFormatColor1 = 7

    Public Const xlRangeAutoFormatColor2 = 8

    Public Const xlRangeAutoFormatColor3 = 9

    Public Const xlRangeAutoFormatList1 = 10

    Public Const xlRangeAutoFormatList2 = 11

    Public Const xlRangeAutoFormatList3 = 12

    Public Const xlRangeAutoFormatLocalFormat1 = 15

    Public Const xlRangeAutoFormatLocalFormat2 = 16

    Public Const xlRangeAutoFormatLocalFormat3 = 19

    Public Const xlRangeAutoFormatLocalFormat4 = 20

    Public Const xlRangeAutoFormatReport1 = 21

    Public Const xlRangeAutoFormatReport2 = 22

    Public Const xlRangeAutoFormatReport3 = 23

    Public Const xlRangeAutoFormatReport4 = 24

    Public Const xlRangeAutoFormatReport5 = 25

    Public Const xlRangeAutoFormatReport6 = 26

    Public Const xlRangeAutoFormatReport7 = 27

    Public Const xlRangeAutoFormatReport8 = 28

    Public Const xlRangeAutoFormatReport9 = 29

    Public Const xlRangeAutoFormatReport10 = 30

    Public Const xlRangeAutoFormatClassicPivotTable = 31

    Public Const xlRangeAutoFormatTable1 = 32

    Public Const xlRangeAutoFormatTable2 = 33

    Public Const xlRangeAutoFormatTable3 = 34

    Public Const xlRangeAutoFormatTable4 = 35

    Public Const xlRangeAutoFormatTable5 = 36

    Public Const xlRangeAutoFormatTable6 = 37

    Public Const xlRangeAutoFormatTable7 = 38

    Public Const xlRangeAutoFormatTable8 = 39

    Public Const xlRangeAutoFormatTable9 = 40

    Public Const xlRangeAutoFormatTable10 = 41

    Public Const xlRangeAutoFormatPTNone = 42

    Public Const xlRangeAutoFormatNone = &HFFFFEFD2

    Public Const xlRangeAutoFormatSimple = &HFFFFEFC6

    'Enum XlReferenceType

    Public Const xlAbsolute = 1

    Public Const xlAbsRowRelColumn = 2

    Public Const xlRelative = 4

    Public Const xlRelRowAbsColumn = 3

    'Enum XlLayoutFormType

    Public Const xlTabular = 0

    Public Const xlOutline = 1

    'Enum XlRoutingSlipDelivery

    Public Const xlAllAtOnce = 2

    Public Const xlOneAfterAnother = 1

    'Enum XlRoutingSlipStatus

    Public Const xlNotYetRouted = 0

    Public Const xlRoutingComplete = 2

    Public Const xlRoutingInProgress = 1

    'Enum XlRunAutoMacro

    Public Const xlAutoActivate = 3

    Public Const xlAutoClose = 2

    Public Const xlAutoDeactivate = 4

    Public Const xlAutoOpen = 1

    'Enum XlSaveAction

    Public Const xlDoNotSaveChanges = 2

    Public Const xlSaveChanges = 1

    'Enum XlSaveAsAccessMode

    Public Const xlExclusive = 3

    Public Const xlNoChange = 1

    Public Const xlShared = 2

    'Enum XlSaveConflictResolution

    Public Const xlLocalSessionChanges = 2

    Public Const xlOtherSessionChanges = 3

    Public Const xlUserResolution = 1

    'Enum XlSearchDirection

    Public Const xlNext = 1

    Public Const xlPrevious = 2

    'Enum XlSearchOrder

    Public Const xlByColumns = 2

    Public Const xlByRows = 1

    'Enum XlSheetVisibility

    Public Const xlSheetVisible = -1

    Public Const xlSheetHidden = 0

    Public Const xlSheetVeryHidden = 2

    'Enum XlSortMethod

    Public Const xlPinYin = 1

    Public Const xlStroke = 2

    'Enum XlSortMethodOld

    Public Const xlCodePage = 2

    Public Const xlSyllabary = 1

    'Enum XlSortOrder

    Public Const xlAscending = 1

    Public Const xlDescending = 2

    'Enum XlSortOrientation

    Public Const xlSortRows = 2

    Public Const xlSortColumns = 1

    'Enum XlSortType

    Public Const xlSortLabels = 2

    Public Const xlSortValues = 1

    'Enum XlSpecialCellsValue

    Public Const xlErrors = 16

    Public Const xlLogical = 4

    Public Const xlNumbers = 1

    Public Const xlTextValues = 2

    'Enum XlSubscribeToFormat

    Public Const xlSubscribeToPicture = &HFFFFEFCD

    Public Const xlSubscribeToText = &HFFFFEFC2

    'Enum XlSummaryRow

    Public Const xlSummaryAbove = 0

    Public Const xlSummaryBelow = 1

    'Enum XlSummaryColumn

    Public Const xlSummaryOnLeft = &HFFFFEFDD

    Public Const xlSummaryOnRight = &HFFFFEFC8

    'Enum XlSummaryReportType

    Public Const xlSummaryPivotTable = &HFFFFEFCC

    Public Const xlStandardSummary = 1

    'Enum XlTabPosition

    Public Const xlTabPositionFirst = 0

    Public Const xlTabPositionLast = 1

    'Enum XlTextParsingType

    Public Const xlDelimited = 1

    Public Const xlFixedWidth = 2

    'Enum XlTextQualifier

    Public Const xlTextQualifierDoubleQuote = 1

    Public Const xlTextQualifierNone = &HFFFFEFD2

    Public Const xlTextQualifierSingleQuote = 2

    'Enum XlWBATemplate

    Public Const xlWBATChart = &HFFFFEFF3

    Public Const xlWBATExcel4IntlMacroSheet = 4

    Public Const xlWBATExcel4MacroSheet = 3

    Public Const xlWBATWorksheet = &HFFFFEFB9

    'Enum XlWindowView

    Public Const xlNormalView = 1

    Public Const xlPageBreakPreview = 2

    'Enum XlXLMMacroType

    Public Const xlCommand = 2

    Public Const xlFunction = 1

    Public Const xlNotXLM = 3

    'Enum XlYesNoGuess

    Public Const xlGuess = 0

    Public Const xlNo = 2

    Public Const xlYes = 1

    'Enum XlBordersIndex

    Public Const xlInsideHorizontal = 12

    Public Const xlInsideVertical = 11

    Public Const xlDiagonalDown = 5

    Public Const xlDiagonalUp = 6

    Public Const xlEdgeBottom = 9

    Public Const xlEdgeLeft = 7

    Public Const xlEdgeRight = 10

    Public Const xlEdgeTop = 8

    'Enum XlToolbarProtection

    Public Const xlNoButtonChanges = 1

    Public Const xlNoChanges = 4

    Public Const xlNoDockingChanges = 3

    Public Const xlToolbarProtectionNone = &HFFFFEFD1

    Public Const xlNoShapeChanges = 2

    'Enum XlBuiltInDialog

    Public Const xlDialogOpen = 1

    Public Const xlDialogOpenLinks = 2

    Public Const xlDialogSaveAs = 5

    Public Const xlDialogFileDelete = 6

    Public Const xlDialogPageSetup = 7

    Public Const xlDialogPrint = 8

    Public Const xlDialogPrinterSetup = 9

    Public Const xlDialogArrangeAll = 12

    Public Const xlDialogWindowSize = 13

    Public Const xlDialogWindowMove = 14

    Public Const xlDialogRun = 17

    Public Const xlDialogSetPrintTitles = 23

    Public Const xlDialogFont = 26

    Public Const xlDialogDisplay = 27

    Public Const xlDialogProtectDocument = 28

    Public Const xlDialogCalculation = 32

    Public Const xlDialogExtract = 35

    Public Const xlDialogDataDelete = 36

    Public Const xlDialogSort = 39

    Public Const xlDialogDataSeries = 40

    Public Const xlDialogTable = 41

    Public Const xlDialogFormatNumber = 42

    Public Const xlDialogAlignment = 43

    Public Const xlDialogStyle = 44

    Public Const xlDialogBorder = 45

    Public Const xlDialogCellProtection = 46

    Public Const xlDialogColumnWidth = 47

    Public Const xlDialogClear = 52

    Public Const xlDialogPasteSpecial = 53

    Public Const xlDialogEditDelete = 54

    Public Const xlDialogInsert = 55

    Public Const xlDialogPasteNames = 58

    Public Const xlDialogDefineName = 61

    Public Const xlDialogCreateNames = 62

    Public Const xlDialogFormulaGoto = 63

    Public Const xlDialogFormulaFind = 64

    Public Const xlDialogGalleryArea = 67

    Public Const xlDialogGalleryBar = 68

    Public Const xlDialogGalleryColumn = 69

    Public Const xlDialogGalleryLine = 70

    Public Const xlDialogGalleryPie = 71

    Public Const xlDialogGalleryScatter = 72

    Public Const xlDialogCombination = 73

    Public Const xlDialogGridlines = 76

    Public Const xlDialogAxes = 78

    Public Const xlDialogAttachText = 80

    Public Const xlDialogPatterns = 84

    Public Const xlDialogMainChart = 85

    Public Const xlDialogOverlay = 86

    Public Const xlDialogScale = 87

    Public Const xlDialogFormatLegend = 88

    Public Const xlDialogFormatText = 89

    Public Const xlDialogParse = 91

    Public Const xlDialogUnhide = 94

    Public Const xlDialogWorkspace = 95

    Public Const xlDialogActivate = 103

    Public Const xlDialogCopyPicture = 108

    Public Const xlDialogDeleteName = 110

    Public Const xlDialogDeleteFormat = 111

    Public Const xlDialogNew = 119

    Public Const xlDialogRowHeight = 127

    Public Const xlDialogFormatMove = 128

    Public Const xlDialogFormatSize = 129

    Public Const xlDialogFormulaReplace = 130

    Public Const xlDialogSelectSpecial = 132

    Public Const xlDialogApplyNames = 133

    Public Const xlDialogReplaceFont = 134

    Public Const xlDialogSplit = 137

    Public Const xlDialogOutline = 142

    Public Const xlDialogSaveWorkbook = 145

    Public Const xlDialogCopyChart = 147

    Public Const xlDialogFormatFont = 150

    Public Const xlDialogNote = 154

    Public Const xlDialogSetUpdateStatus = 159

    Public Const xlDialogColorPalette = 161

    Public Const xlDialogChangeLink = 166

    Public Const xlDialogAppMove = 170

    Public Const xlDialogAppSize = 171

    Public Const xlDialogMainChartType = 185

    Public Const xlDialogOverlayChartType = 186

    Public Const xlDialogOpenMail = 188

    Public Const xlDialogSendMail = 189

    Public Const xlDialogStandardFont = 190

    Public Const xlDialogConsolidate = 191

    Public Const xlDialogSortSpecial = 192

    Public Const xlDialogGallery3dArea = 193

    Public Const xlDialogGallery3dColumn = 194

    Public Const xlDialogGallery3dLine = 195

    Public Const xlDialogGallery3dPie = 196

    Public Const xlDialogView3d = 197

    Public Const xlDialogGoalSeek = 198

    Public Const xlDialogWorkgroup = 199

    Public Const xlDialogFillGroup = 200

    Public Const xlDialogUpdateLink = 201

    Public Const xlDialogPromote = 202

    Public Const xlDialogDemote = 203

    Public Const xlDialogShowDetail = 204

    Public Const xlDialogObjectProperties = 207

    Public Const xlDialogSaveNewObject = 208

    Public Const xlDialogApplyStyle = 212

    Public Const xlDialogAssignToObject = 213

    Public Const xlDialogObjectProtection = 214

    Public Const xlDialogCreatePublisher = 217

    Public Const xlDialogSubscribeTo = 218

    Public Const xlDialogShowToolbar = 220

    Public Const xlDialogPrintPreview = 222

    Public Const xlDialogEditColor = 223

    Public Const xlDialogFormatMain = 225

    Public Const xlDialogFormatOverlay = 226

    Public Const xlDialogEditSeries = 228

    Public Const xlDialogDefineStyle = 229

    Public Const xlDialogGalleryRadar = 249

    Public Const xlDialogEditionOptions = 251

    Public Const xlDialogZoom = &H100

    Public Const xlDialogInsertObject = &H103

    Public Const xlDialogSize = &H105

    Public Const xlDialogMove = &H106

    Public Const xlDialogFormatAuto = &H10D

    Public Const xlDialogGallery3dBar = &H110

    Public Const xlDialogGallery3dSurface = &H111

    Public Const xlDialogCustomizeToolbar = &H114

    Public Const xlDialogWorkbookAdd = &H119

    Public Const xlDialogWorkbookMove = &H11A

    Public Const xlDialogWorkbookCopy = &H11B

    Public Const xlDialogWorkbookOptions = &H11C

    Public Const xlDialogSaveWorkspace = &H11D

    Public Const xlDialogChartWizard = &H120

    Public Const xlDialogAssignToTool = &H125

    Public Const xlDialogPlacement = &H12C

    Public Const xlDialogFillWorkgroup = &H12D

    Public Const xlDialogWorkbookNew = &H12E

    Public Const xlDialogScenarioCells = &H131

    Public Const xlDialogScenarioAdd = &H133

    Public Const xlDialogScenarioEdit = &H134

    Public Const xlDialogScenarioSummary = &H137

    Public Const xlDialogPivotTableWizard = &H138

    Public Const xlDialogPivotFieldProperties = &H139

    Public Const xlDialogOptionsCalculation = &H13E

    Public Const xlDialogOptionsEdit = &H13F

    Public Const xlDialogOptionsView = &H140

    Public Const xlDialogAddinManager = &H141

    Public Const xlDialogMenuEditor = &H142

    Public Const xlDialogAttachToolbars = &H143

    Public Const xlDialogOptionsChart = &H145

    Public Const xlDialogVbaInsertFile = &H148

    Public Const xlDialogVbaProcedureDefinition = &H14A

    Public Const xlDialogRoutingSlip = &H150

    Public Const xlDialogMailLogon = &H153

    Public Const xlDialogInsertPicture = &H156

    Public Const xlDialogGalleryDoughnut = &H158

    Public Const xlDialogChartTrend = &H15E

    Public Const xlDialogWorkbookInsert = &H162

    Public Const xlDialogOptionsTransition = &H163

    Public Const xlDialogOptionsGeneral = &H164

    Public Const xlDialogFilterAdvanced = &H172

    Public Const xlDialogMailNextLetter = &H17A

    Public Const xlDialogDataLabel = &H17B

    Public Const xlDialogInsertTitle = &H17C

    Public Const xlDialogFontProperties = &H17D

    Public Const xlDialogMacroOptions = &H17E

    Public Const xlDialogWorkbookUnhide = &H180

    Public Const xlDialogWorkbookName = &H182

    Public Const xlDialogGalleryCustom = &H184

    Public Const xlDialogAddChartAutoformat = &H186

    Public Const xlDialogChartAddData = &H188

    Public Const xlDialogTabOrder = &H18A

    Public Const xlDialogSubtotalCreate = &H18E

    Public Const xlDialogWorkbookTabSplit = &H19F

    Public Const xlDialogWorkbookProtect = &H1A1

    Public Const xlDialogScrollbarProperties = &H1A4

    Public Const xlDialogPivotShowPages = &H1A5

    Public Const xlDialogTextToColumns = &H1A6

    Public Const xlDialogFormatCharttype = &H1A7

    Public Const xlDialogPivotFieldGroup = &H1B1

    Public Const xlDialogPivotFieldUngroup = &H1B2

    Public Const xlDialogCheckboxProperties = &H1B3

    Public Const xlDialogLabelProperties = &H1B4

    Public Const xlDialogListboxProperties = &H1B5

    Public Const xlDialogEditboxProperties = &H1B6

    Public Const xlDialogOpenText = &H1B9

    Public Const xlDialogPushbuttonProperties = &H1BD

    Public Const xlDialogFilter = &H1BF

    Public Const xlDialogFunctionWizard = &H1C2

    Public Const xlDialogSaveCopyAs = &H1C8

    Public Const xlDialogOptionsListsAdd = &H1CA

    Public Const xlDialogSeriesAxes = &H1CC

    Public Const xlDialogSeriesX = &H1CD

    Public Const xlDialogSeriesY = &H1CE

    Public Const xlDialogErrorbarX = &H1CF

    Public Const xlDialogErrorbarY = &H1D0

    Public Const xlDialogFormatChart = &H1D1

    Public Const xlDialogSeriesOrder = &H1D2

    Public Const xlDialogMailEditMailer = &H1D6

    Public Const xlDialogStandardWidth = &H1D8

    Public Const xlDialogScenarioMerge = &H1D9

    Public Const xlDialogProperties = &H1DA

    Public Const xlDialogSummaryInfo = &H1DA

    Public Const xlDialogFindFile = &H1DB

    Public Const xlDialogActiveCellFont = &H1DC

    Public Const xlDialogVbaMakeAddin = &H1DE

    Public Const xlDialogFileSharing = &H1E1

    Public Const xlDialogAutoCorrect = &H1E5

    Public Const xlDialogCustomViews = &H1ED

    Public Const xlDialogInsertNameLabel = &H1F0

    Public Const xlDialogSeriesShape = &H1F8

    Public Const xlDialogChartOptionsDataLabels = &H1F9

    Public Const xlDialogChartOptionsDataTable = &H1FA

    Public Const xlDialogSetBackgroundPicture = &H1FD

    Public Const xlDialogDataValidation = &H20D

    Public Const xlDialogChartType = &H20E

    Public Const xlDialogChartLocation = &H20F

    Public Const _xlDialogPhonetic = &H21A

    Public Const xlDialogChartSourceData = &H21C

    Public Const _xlDialogChartSourceData = &H21D

    Public Const xlDialogSeriesOptions = &H22D

    Public Const xlDialogPivotTableOptions = &H237

    Public Const xlDialogPivotSolveOrder = &H238

    Public Const xlDialogPivotCalculatedField = &H23A

    Public Const xlDialogPivotCalculatedItem = &H23C

    Public Const xlDialogConditionalFormatting = &H247

    Public Const xlDialogInsertHyperlink = &H254

    Public Const xlDialogProtectSharing = &H26C

    Public Const xlDialogOptionsME = &H287

    Public Const xlDialogPublishAsWebPage = &H28D

    Public Const xlDialogPhonetic = &H290

    Public Const xlDialogNewWebQuery = &H29B

    Public Const xlDialogImportTextFile = &H29A

    Public Const xlDialogExternalDataProperties = &H212

    Public Const xlDialogWebOptionsGeneral = &H2AB

    Public Const xlDialogWebOptionsFiles = &H2AC

    Public Const xlDialogWebOptionsPictures = &H2AD

    Public Const xlDialogWebOptionsEncoding = &H2AE

    Public Const xlDialogWebOptionsFonts = &H2AF

    Public Const xlDialogPivotClientServerSet = &H2B1

    'Enum XlParameterType

    Public Const xlPrompt = 0

    Public Const xlConstant = 1

    Public Const xlRange = 2

    'Enum XlParameterDataType

    Public Const xlParamTypeUnknown = 0

    Public Const xlParamTypeChar = 1

    Public Const xlParamTypEnumeric = 2

    Public Const xlParamTypeDecimal = 3

    Public Const xlParamTypeInteger = 4

    Public Const xlParamTypeSmallInt = 5

    Public Const xlParamTypeFloat = 6

    Public Const xlParamTypeReal = 7

    Public Const xlParamTypeDouble = 8

    Public Const xlParamTypeVarChar = 12

    Public Const xlParamTypeDate = 9

    Public Const xlParamTypeTime = 10

    Public Const xlParamTypeTimestamp = 11

    Public Const xlParamTypeLongVarChar = -1

    Public Const xlParamTypeBinary = -2

    Public Const xlParamTypeVarBinary = -3

    Public Const xlParamTypeLongVarBinary = -4

    Public Const xlParamTypeBigInt = -5

    Public Const xlParamTypeTinyInt = -6

    Public Const xlParamTypeBit = -7

    Public Const xlParamTypeWChar = -8

    'Enum XlFormControl

    Public Const xlButtonControl = 0

    Public Const xlCheckBox = 1

    Public Const xlDropDown = 2

    Public Const xlEditBox = 3

    Public Const xlGroupBox = 4

    Public Const xlLabel = 5

    Public Const xlListBox = 6

    Public Const xlOptionButton = 7

    Public Const xlScrollBar = 8

    Public Const xlSpinner = 9

    'Enum XlSourceType

    Public Const xlSourceSheet = 1

    Public Const xlSourcePrintArea = 2

    Public Const xlSourceAutoFilter = 3

    Public Const xlSourceRange = 4

    Public Const xlSourceChart = 5

    Public Const xlSourcePivotTable = 6

    Public Const xlSourceQuery = 7

    'Enum XlHtmlType

    Public Const xlHtmlStatic = 0

    Public Const xlHtmlCalc = 1

    Public Const xlHtmlList = 2

    Public Const xlHtmlChart = 3

    'Enum xlPivotFormatType

    Public Const xlReport1 = 0

    Public Const xlReport2 = 1

    Public Const xlReport3 = 2

    Public Const xlReport4 = 3

    Public Const xlReport5 = 4

    Public Const xlReport6 = 5

    Public Const xlReport7 = 6

    Public Const xlReport8 = 7

    Public Const xlReport9 = 8

    Public Const xlReport10 = 9

    Public Const xlTable1 = 10

    Public Const xlTable2 = 11

    Public Const xlTable3 = 12

    Public Const xlTable4 = 13

    Public Const xlTable5 = 14

    Public Const xlTable6 = 15

    Public Const xlTable7 = 16

    Public Const xlTable8 = 17

    Public Const xlTable9 = 18

    Public Const xlTable10 = 19

    Public Const xlPTClassic = 20

    Public Const xlPTNone = 21

    'Enum XlCmdType

    Public Const xlCmdCube = 1

    Public Const xlCmdSql = 2

    Public Const xlCmdTable = 3

    Public Const xlCmdDefault = 4

    'Enum xlColumnDataType

    Public Const xlGeneralFormat = 1

    Public Const xlTextFormat = 2

    Public Const xlMDYFormat = 3

    Public Const xlDMYFormat = 4

    Public Const xlYMDFormat = 5

    Public Const xlMYDFormat = 6

    Public Const xlDYMFormat = 7

    Public Const xlYDMFormat = 8

    Public Const xlSkipColumn = 9

    Public Const xlEMDFormat = 10

    'Enum xlQueryType

    Public Const xlODBCQuery = 1

    Public Const xlDAORecordSet = 2

    Public Const xlWebQuery = 4

    Public Const xlOLEDBQuery = 5

    Public Const xlTextImport = 6

    Public Const xlADORecordset = 7

    'Enum xlWebSelectionType

    Public Const xlEntirePage = 1

    Public Const xlAllTables = 2

    Public Const xlSpecifiedTables = 3

    'Enum XlCubeFieldType

    Public Const xlHierarchy = 1

    Public Const xlMeasure = 2

    'Enum xlWebFormatting

    Public Const xlWebFormattingAll = 1

    Public Const xlWebFormattingRTF = 2

    Public Const xlWebFormattingNone = 3

    'Enum xlDisplayDrawingObjects

    Public Const xlDisplayShapes = &HFFFFEFF8

    Public Const xlHide = 3

    Public Const xlPlaceholders = 2

    'Enum xLSubtototalLocationType

    Public Const xlAtTop = 1

    Public Const xlAtBottom = 2

  • 3
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值