This is a list of all the Excel constants
Constants
XlCreator
XlChartGallery
XlColorIndex
XlEndStyleCap
XlRowCol
XlScaleType
XlDataSeriesType
XlAxisCrosses
XlAxisGroup
XlBackground
XlWindowState
XlAxisType
XlArrowHeadLength
XlVAlign
XlTickMark
XlErrorBarDirection
XlErrorBarInclude
XlDisplayBlanksAs
XlArrowHeadStyle
XlArrowHeadWidth
XlHAlign
XlTickLabelPosition
XlLegendPosition
XlChartPictureType
XlChartPicturePlacement
XlOrientation
XlTickLabelOrientation
XlBorderWeight
XlDataSeriesDate
XlUnderlineStyle
XlErrorBarType
XlTrendlineType
XlLineStyle
XlDataLabelsType
XlMarkerStyle
XlPictureConvertorType
XlPattern
XlChartSplitType
XlDisplayUnit
XlDataLabelPosition
XlTimeUnit
XlCategoryType
XlBarShape
XlChartType
XlChartItem
XlSizeRepresents
XlInsertShiftDirection
XlDeleteShiftDirection
XlDirection
XlConsolidationFunction
XlSheetType
XlLocationInTable
XlFindLookIn
XlWindowType
XlPivotFieldDataType
XlCopyPictureFormat
XlPivotTableSourceType
XlReferenceStyle
XlMSApplication
XlMouseButton
XlCutCopyMode
XlFillWith
XlFilterAction
XlOrder
XlLinkType
XlApplyNamesOrder
XlEnableCancelKey
XlPageBreak
XlOLEType
XlPageOrientation
XlLinkInfo
XlCommandUnderlines
XlOLEVerb
XlCalculation
XlFileAccess
XlEditionType
XlObjectSize
XlLookAt
XlMailSystem
XlLinkInfoType
XlCVError
XlEditionFormat
XlLink
XlCellType
XlArrangeStyle
XlMousePointer
XlEditionOptionsOption
XlAutoFillType
XlAutoFilterOperator
XlClipboardFormat
XlFileFormat
XlApplicationInternational
XlPageBreakExtent
XlCellInsertionMode
XlFormulaLabel
XlHighlightChangesTime
XlCommentDisplayMode
XlFormatConditionType
XlFormatConditionOperator
XlEnableSelection
XlDVType
XlIMEMode
XlDVAlertStyle
XlChartLocation
XlPaperSize
XlPasteSpecialOperation
XlPasteType
XlPhoneticCharacterType
XlPhoneticAlignment
XlPictureAppearance
XlPivotFieldOrientation
XlPivotFieldCalculation
XlPlacement
XlPlatform
XlPrintLocation
XlPriority
XlPTSelectionMode
XlRangeAutoFormat
XlReferenceType
XlLayoutFormType
XlRoutingSlipDelivery
XlRoutingSlipStatus
XlRunAutoMacro
XlSaveAction
XlSaveAsAccessMode
XlSaveConflictResolution
XlSearchDirection
XlSearchOrder
XlSheetVisibility
XlSortMethod
XlSortMethodOld
XlSortOrder
XlSortOrientation
XlSortType
XlSpecialCellsValue
XlSubscribeToFormat
XlSummaryRow
XlSummaryColumn
XlSummaryReportType
XlTabPosition
XlTextParsingType
XlTextQualifier
XlWBATemplate
XlWindowView
XlXLMMacroType
XlYesNoGuess
XlBordersIndex
XlToolbarProtection
XlBuiltInDialog
XlParameterType
XlParameterDataType
XlFormControl
XlSourceType
XlHtmlType
XlPivotFormatType
XlCmdType
XlColumnDataType
XlQueryType
XlWebSelectionType
XlCubeFieldType
XlWebFormatting
XlDisplayDrawingObjects
XlSubtototalLocationType
XlPivotTableVersionList
XlPrintErrors
XlPivotCellType
XlPivotTableMissingItems
XlCalculationState
XlCalculationInterruptKey
XlSortDataOption
XlUpdateLinks
XlLinkStatus
XlSearchWithin
XlCorruptLoad
XlRobustConnect
XlErrorChecks
XlDataLabelSeparator
XlSmartTagDisplayMode
XlRangeValueDataType
XlSpeakDirection
XlInsertFormatOrigin
XlArabicModes
XlImportDataAs
XlCalculatedMemberType
XlHebrewModes
XlListObjectSourceType
XlTextVisualLayoutType
XlListDataType
XlTotalsCalculation
XlXmlLoadOption
XlSmartTagControlType
XlListConflict
XlXmlExportResult
XlXmlImportResult
|
‘ Constants for use in mrStudio CONST xlAll = -4104 CONST xlAutomatic = -4105 CONST xlBoth = 1 CONST xlCenter = -4108 CONST xlChecker = 9 CONST xlCircle = 8 CONST xlCorner = 2 CONST xlCrissCross = 16 CONST xlCross = 4 CONST xlDiamond = 2 CONST xlDistributed = -4117 CONST xlDoubleAccounting = 5 CONST xlFixedValue = 1 CONST xlFormats = -4122 CONST xlGray16 = 17 CONST xlGray8 = 18 CONST xlGrid = 15 CONST xlHigh = -4127 CONST xlInside = 2 CONST xlJustify = -4130 CONST xlLightDown = 13 CONST xlLightHorizontal = 11 CONST xlLightUp = 14 CONST xlLightVertical = 12 CONST xlLow = -4134 CONST xlManual = -4135 CONST xlMinusValues = 3 CONST xlModule = -4141 CONST xlNextToAxis = 4 CONST xlNone = -4142 CONST xlNotes = -4144 CONST xlOff = -4146 CONST xlOn = 1 CONST xlPercent = 2 CONST xlPlus = 9 CONST xlPlusValues = 2 CONST xlSemiGray75 = 10 CONST xlShowLabel = 4 CONST xlShowLabelAndPercent = 5 CONST xlShowPercent = 3 CONST xlShowValue = 2 CONST xlSimple = -4154 CONST xlSingle = 2 CONST xlSingleAccounting = 4 CONST xlSolid = 1 CONST xlSquare = 1 CONST xlStar = 5 CONST xlStError = 4 CONST xlToolbarButton = 2 CONST xlTriangle = 3 CONST xlGray25 = -4124 CONST xlGray50 = -4125 CONST xlGray75 = -4126 CONST xlBottom = -4107 CONST xlLeft = -4131 CONST xlRight = -4152 CONST xlTop = -4160 CONST xl3DBar = -4099 CONST xl3DSurface = -4103 CONST xlBar = 2 CONST xlColumn = 3 CONST xlCombination = -4111 CONST xlCustom = -4114 CONST xlDefaultAutoFormat = -1 CONST xlMaximum = 2 CONST xlMinimum = 4 CONST xlOpaque = 3 CONST xlTransparent = 2 CONST xlBidi = -5000 CONST xlLatin = -5001 CONST xlContext = -5002 CONST xlLTR = -5003 CONST xlRTL = -5004 CONST xlFullScript = 1 CONST xlPartialScript = 2 CONST xlMixedScript = 3 CONST xlMixedAuthorizedScript = 4 CONST xlVisualCursor = 2 CONST xlLogicalCursor = 1 CONST xlSystem = 1 CONST xlPartial = 3 CONST xlHindiNumerals = 3 CONST xlBidiCalendar = 3 CONST xlGregorian = 2 CONST xlComplete = 4 CONST xlScale = 3 CONST xlClosed = 3 CONST xlColor1 = 7 CONST xlColor2 = 8 CONST xlColor3 = 9 CONST xlConstants = 2 CONST xlContents = 2 CONST xlBelow = 1 CONST xlCascade = 7 CONST xlCenterAcrossSelection = 7 CONST xlChart4 = 2 CONST xlChartSeries = 17 CONST xlChartShort = 6 CONST xlChartTitles = 18 CONST xlClassic1 = 1 CONST xlClassic2 = 2 CONST xlClassic3 = 3 CONST xl3DEffects1 = 13 CONST xl3DEffects2 = 14 CONST xlAbove = 0 CONST xlAccounting1 = 4 CONST xlAccounting2 = 5 CONST xlAccounting3 = 6 CONST xlAccounting4 = 17 CONST xlAdd = 2 CONST xlDebugCodePane = 13 CONST xlDesktop = 9 CONST xlDirect = 1 CONST xlDivide = 5 CONST xlDoubleClosed = 5 CONST xlDoubleOpen = 4 CONST xlDoubleQuote = 1 CONST xlEntireChart = 20 CONST xlExcelMenus = 1 CONST xlExtended = 3 CONST xlFill = 5 CONST xlFirst = 0 CONST xlFloating = 5 CONST xlFormula = 5 CONST xlGeneral = 1 CONST xlGridline = 22 CONST xlIcons = 1 CONST xlImmediatePane = 12 CONST xlInteger = 2 CONST xlLast = 1 CONST xlLastCell = 11 CONST xlList1 = 10 CONST xlList2 = 11 CONST xlList3 = 12 CONST xlLocalFormat1 = 15 CONST xlLocalFormat2 = 16 CONST xlLong = 3 CONST xlLotusHelp = 2 CONST xlMacrosheetCell = 7 CONST xlMixed = 2 CONST xlMultiply = 4 CONST xlNarrow = 1 CONST xlNoDocuments = 3 CONST xlOpen = 2 CONST xlOutside = 3 CONST xlReference = 4 CONST xlSemiautomatic = 2 CONST xlShort = 1 CONST xlSingleQuote = 2 CONST xlStrict = 2 CONST xlSubtract = 3 CONST xlTextBox = 16 CONST xlTiled = 1 CONST xlTitleBar = 8 CONST xlToolbar = 1 CONST xlVisible = 12 CONST xlWatchPane = 11 CONST xlWide = 3 CONST xlWorkbookTab = 6 CONST xlWorksheet4 = 1 CONST xlWorksheetCell = 3 CONST xlWorksheetShort = 5 CONST xlAllExceptBorders = 7 CONST xlLeftToRight = 2 CONST xlTopToBottom = 1 CONST xlVeryHidden = 2 CONST xlDrawingObject = 14 CONST xlCreatorCode = 1480803660 CONST xlBuiltIn = 21 CONST xlUserDefined = 22 CONST xlAnyGallery = 23 CONST xlColorIndexAutomatic = -4105 CONST xlColorIndexNone = -4142 CONST xlCap = 1 CONST xlNoCap = 2 CONST xlColumns = 2 CONST xlRows = 1 CONST xlScaleLinear = -4132 CONST xlScaleLogarithmic = -4133 CONST xlAutoFill = 4 CONST xlChronological = 3 CONST xlGrowth = 2 CONST xlDataSeriesLinear = -4132 CONST xlAxisCrossesAutomatic = -4105 CONST xlAxisCrossesCustom = -4114 CONST xlAxisCrossesMaximum = 2 CONST xlAxisCrossesMinimum = 4 CONST xlPrimary = 1 CONST xlSecondary = 2 CONST xlBackgroundAutomatic = -4105 CONST xlBackgroundOpaque = 3 CONST xlBackgroundTransparent = 2 CONST xlMaximized = -4137 CONST xlMinimized = -4140 CONST xlNormal = -4143 CONST xlCategory = 1 CONST xlSeriesAxis = 3 CONST xlValue = 2 CONST xlArrowHeadLengthLong = 3 CONST xlArrowHeadLengthMedium = -4138 CONST xlArrowHeadLengthShort = 1 CONST xlVAlignBottom = -4107 CONST xlVAlignCenter = -4108 CONST xlVAlignDistributed = -4117 CONST xlVAlignJustify = -4130 CONST xlVAlignTop = -4160 CONST xlTickMarkCross = 4 CONST xlTickMarkInside = 2 CONST xlTickMarkNone = -4142 CONST xlTickMarkOutside = 3 CONST xlX = -4168 CONST xlY = 1 CONST xlErrorBarIncludeBoth = 1 CONST xlErrorBarIncludeMinusValues = 3 CONST xlErrorBarIncludeNone = -4142 CONST xlErrorBarIncludePlusValues = 2 CONST xlInterpolated = 3 CONST xlNotPlotted = 1 CONST xlZero = 2 CONST xlArrowHeadStyleClosed = 3 CONST xlArrowHeadStyleDoubleClosed = 5 CONST xlArrowHeadStyleDoubleOpen = 4 CONST xlArrowHeadStyleNone = -4142 CONST xlArrowHeadStyleOpen = 2 CONST xlArrowHeadWidthMedium = -4138 CONST xlArrowHeadWidthNarrow = 1 CONST xlArrowHeadWidthWide = 3 CONST xlHAlignCenter = -4108 CONST xlHAlignCenterAcrossSelection = 7 CONST xlHAlignDistributed = -4117 CONST xlHAlignFill = 5 CONST xlHAlignGeneral = 1 CONST xlHAlignJustify = -4130 CONST xlHAlignLeft = -4131 CONST xlHAlignRight = -4152 CONST xlTickLabelPositionHigh = -4127 CONST xlTickLabelPositionLow = -4134 CONST xlTickLabelPositionNextToAxis = 4 CONST xlTickLabelPositionNone = -4142 CONST xlLegendPositionBottom = -4107 CONST xlLegendPositionCorner = 2 CONST xlLegendPositionLeft = -4131 CONST xlLegendPositionRight = -4152 CONST xlLegendPositionTop = -4160 CONST xlStackScale = 3 CONST xlStack = 2 CONST xlStretch = 1 CONST xlSides = 1 CONST xlEnd = 2 CONST xlEndSides = 3 CONST xlFront = 4 CONST xlFrontSides = 5 CONST xlFrontEnd = 6 CONST xlAllFaces = 7 CONST xlDownward = -4170 CONST xlHorizontal = -4128 CONST xlUpward = -4171 CONST xlVertical = -4166 CONST xlTickLabelOrientationAutomatic = -4105 CONST xlTickLabelOrientationDownward = -4170 CONST xlTickLabelOrientationHorizontal = -4128 CONST xlTickLabelOrientationUpward = -4171 CONST xlTickLabelOrientationVertical = -4166 CONST xlHairline = 1 CONST xlMedium = -4138 CONST xlThick = 4 CONST xlThin = 2 CONST xlDay = 1 CONST xlMonth = 3 CONST xlWeekday = 2 CONST xlYear = 4 CONST xlUnderlineStyleDouble = -4119 CONST xlUnderlineStyleDoubleAccounting = 5 CONST xlUnderlineStyleNone = -4142 CONST xlUnderlineStyleSingle = 2 CONST xlUnderlineStyleSingleAccounting = 4 CONST xlErrorBarTypeCustom = -4114 CONST xlErrorBarTypeFixedValue = 1 CONST xlErrorBarTypePercent = 2 CONST xlErrorBarTypeStDev = -4155 CONST xlErrorBarTypeStError = 4 CONST xlExponential = 5 CONST xlLinear = -4132 CONST xlLogarithmic = -4133 CONST xlMovingAvg = 6 CONST xlPolynomial = 3 CONST xlPower = 4 CONST xlContinuous = 1 CONST xlDash = -4115 CONST xlDashDot = 4 CONST xlDashDotDot = 5 CONST xlDot = -4118 CONST xlDouble = -4119 CONST xlSlantDashDot = 13 CONST xlLineStyleNone = -4142 CONST xlDataLabelsShowNone = -4142 CONST xlDataLabelsShowValue = 2 CONST xlDataLabelsShowPercent = 3 CONST xlDataLabelsShowLabel = 4 CONST xlDataLabelsShowLabelAndPercent = 5 CONST xlDataLabelsShowBubbleSizes = 6 CONST xlMarkerStyleAutomatic = -4105 CONST xlMarkerStyleCircle = 8 CONST xlMarkerStyleDash = -4115 CONST xlMarkerStyleDiamond = 2 CONST xlMarkerStyleDot = -4118 CONST xlMarkerStyleNone = -4142 CONST xlMarkerStylePicture = -4147 CONST xlMarkerStylePlus = 9 CONST xlMarkerStyleSquare = 1 CONST xlMarkerStyleStar = 5 CONST xlMarkerStyleTriangle = 3 CONST xlMarkerStyleX = -4168 CONST xlBMP = 1 CONST xlCGM = 7 CONST xlDRW = 4 CONST xlDXF = 5 CONST xlEPS = 8 CONST xlHGL = 6 CONST xlPCT = 13 CONST xlPCX = 10 CONST xlPIC = 11 CONST xlPLT = 12 CONST xlTIF = 9 CONST xlWMF = 2 CONST xlWPG = 3 CONST xlPatternAutomatic = -4105 CONST xlPatternChecker = 9 CONST xlPatternCrissCross = 16 CONST xlPatternDown = -4121 CONST xlPatternGray16 = 17 CONST xlPatternGray25 = -4124 CONST xlPatternGray50 = -4125 CONST xlPatternGray75 = -4126 CONST xlPatternGray8 = 18 CONST xlPatternGrid = 15 CONST xlPatternHorizontal = -4128 CONST xlPatternLightDown = 13 CONST xlPatternLightHorizontal = 11 CONST xlPatternLightUp = 14 CONST xlPatternLightVertical = 12 CONST xlPatternNone = -4142 CONST xlPatternSemiGray75 = 10 CONST xlPatternSolid = 1 CONST xlPatternUp = -4162 CONST xlPatternVertical = -4166 CONST xlSplitByPosition = 1 CONST xlSplitByPercentValue = 3 CONST xlSplitByCustomSplit = 4 CONST xlSplitByValue = 2 CONST xlHundreds = -2 CONST xlThousands = -3 CONST xlTenThousands = -4 CONST xlHundredThousands = -5 CONST xlMillions = -6 CONST xlTenMillions = -7 CONST xlHundredMillions = -8 CONST xlThousandMillions = -9 CONST xlMillionMillions = -10 CONST xlLabelPositionCenter = -4108 CONST xlLabelPositionAbove = 0 CONST xlLabelPositionBelow = 1 CONST xlLabelPositionLeft = -4131 CONST xlLabelPositionRight = -4152 CONST xlLabelPositionOutsideEnd = 2 CONST xlLabelPositionInsideEnd = 3 CONST xlLabelPositionInsideBase = 4 CONST xlLabelPositionBestFit = 5 CONST xlLabelPositionMixed = 6 CONST xlLabelPositionCustom = 7 CONST xlDays = 0 CONST xlMonths = 1 CONST xlYears = 2 CONST xlCategoryScale = 2 CONST xlTimeScale = 3 CONST xlAutomaticScale = -4105 CONST xlBox = 0 CONST xlPyramidToPoint = 1 CONST xlPyramidToMax = 2 CONST xlCylinder = 3 CONST xlConeToPoint = 4 CONST xlConeToMax = 5 CONST xlColumnClustered = 51 CONST xlColumnStacked = 52 CONST xlColumnStacked100 = 53 CONST xl3DColumnClustered = 54 CONST xl3DColumnStacked = 55 CONST xl3DColumnStacked100 = 56 CONST xlBarClustered = 57 CONST xlBarStacked = 58 CONST xlBarStacked100 = 59 CONST xl3DBarClustered = 60 CONST xl3DBarStacked = 61 CONST xl3DBarStacked100 = 62 CONST xlLineStacked = 63 CONST xlLineStacked100 = 64 CONST xlLineMarkers = 65 CONST xlLineMarkersStacked = 66 CONST xlLineMarkersStacked100 = 67 CONST xlPieOfPie = 68 CONST xlPieExploded = 69 CONST xl3DPieExploded = 70 CONST xlBarOfPie = 71 CONST xlXYScatterSmooth = 72 CONST xlXYScatterSmoothNoMarkers = 73 CONST xlXYScatterLines = 74 CONST xlXYScatterLinesNoMarkers = 75 CONST xlAreaStacked = 76 CONST xlAreaStacked100 = 77 CONST xl3DAreaStacked = 78 CONST xl3DAreaStacked100 = 79 CONST xlDoughnutExploded = 80 CONST xlRadarMarkers = 81 CONST xlRadarFilled = 82 CONST xlSurface = 83 CONST xlSurfaceWireframe = 84 CONST xlSurfaceTopView = 85 CONST xlSurfaceTopViewWireframe = 86 CONST xlBubble = 15 CONST xlBubble3DEffect = 87 CONST xlStockHLC = 88 CONST xlStockOHLC = 89 CONST xlStockVHLC = 90 CONST xlStockVOHLC = 91 CONST xlCylinderColClustered = 92 CONST xlCylinderColStacked = 93 CONST xlCylinderColStacked100 = 94 CONST xlCylinderBarClustered = 95 CONST xlCylinderBarStacked = 96 CONST xlCylinderBarStacked100 = 97 CONST xlCylinderCol = 98 CONST xlConeColClustered = 99 CONST xlConeColStacked = 100 CONST xlConeColStacked100 = 101 CONST xlConeBarClustered = 102 CONST xlConeBarStacked = 103 CONST xlConeBarStacked100 = 104 CONST xlConeCol = 105 CONST xlPyramidColClustered = 106 CONST xlPyramidColStacked = 107 CONST xlPyramidColStacked100 = 108 CONST xlPyramidBarClustered = 109 CONST xlPyramidBarStacked = 110 CONST xlPyramidBarStacked100 = 111 CONST xlPyramidCol = 112 CONST xl3DColumn = -4100 CONST xlLine = 4 CONST xl3DLine = -4101 CONST xl3DPie = -4102 CONST xlPie = 5 CONST xlXYScatter = -4169 CONST xl3DArea = -4098 CONST xlArea = 1 CONST xlDoughnut = -4120 CONST xlRadar = -4151 CONST xlDataLabel = 0 CONST xlChartArea = 2 CONST xlSeries = 3 CONST xlChartTitle = 4 CONST xlWalls = 5 CONST xlCorners = 6 CONST xlDataTable = 7 CONST xlTrendline = 8 CONST xlErrorBars = 9 CONST xlXErrorBars = 10 CONST xlYErrorBars = 11 CONST xlLegendEntry = 12 CONST xlLegendKey = 13 CONST xlShape = 14 CONST xlMajorGridlines = 15 CONST xlMinorGridlines = 16 CONST xlAxisTitle = 17 CONST xlUpBars = 18 CONST xlPlotArea = 19 CONST xlDownBars = 20 CONST xlAxis = 21 CONST xlSeriesLines = 22 CONST xlFloor = 23 CONST xlLegend = 24 CONST xlHiLoLines = 25 CONST xlDropLines = 26 CONST xlRadarAxisLabels = 27 CONST xlNothing = 28 CONST xlLeaderLines = 29 CONST xlDisplayUnitLabel = 30 CONST xlPivotChartFieldButton = 31 CONST xlPivotChartDropZone = 32 CONST xlSizeIsWidth = 2 CONST xlSizeIsArea = 1 CONST xlShiftDown = -4121 CONST xlShiftToRight = -4161 CONST xlShiftToLeft = -4159 CONST xlShiftUp = -4162 CONST xlDown = -4121 CONST xlToLeft = -4159 CONST xlToRight = -4161 CONST xlUp = -4162 CONST xlAverage = -4106 CONST xlCount = -4112 CONST xlCountNums = -4113 CONST xlMax = -4136 CONST xlMin = -4139 CONST xlProduct = -4149 CONST xlStDev = -4155 CONST xlStDevP = -4156 CONST xlSum = -4157 CONST xlVar = -4164 CONST xlVarP = -4165 CONST xlUnknown = 1000 CONST xlChart = -4109 CONST xlDialogSheet = -4116 CONST xlExcel4IntlMacroSheet = 4 CONST xlExcel4MacroSheet = 3 CONST xlWorksheet = -4167 CONST xlColumnHeader = -4110 CONST xlColumnItem = 5 CONST xlDataHeader = 3 CONST xlDataItem = 7 CONST xlPageHeader = 2 CONST xlPageItem = 6 CONST xlRowHeader = -4153 CONST xlRowItem = 4 CONST xlTableBody = 8 CONST xlFormulas = -4123 CONST xlComments = -4144 CONST xlValues = -4163 CONST xlChartAsWindow = 5 CONST xlChartInPlace = 4 CONST xlClipboard = 3 CONST xlInfo = -4129 CONST xlWorkbook = 1 CONST xlDate = 2 CONST xlNumber = -4145 CONST xlText = -4158 CONST xlBitmap = 2 CONST xlPicture = -4147 CONST xlScenario = 4 CONST xlConsolidation = 3 CONST xlDatabase = 1 CONST xlExternal = 2 CONST xlPivotTable = -4148 CONST xlA1 = 1 CONST xlR1C1 = -4150 CONST xlMicrosoftAccess = 4 CONST xlMicrosoftFoxPro = 5 CONST xlMicrosoftMail = 3 CONST xlMicrosoftPowerPoint = 2 CONST xlMicrosoftProject = 6 CONST xlMicrosoftSchedulePlus = 7 CONST xlMicrosoftWord = 1 CONST xlNoButton = 0 CONST xlPrimaryButton = 1 CONST xlSecondaryButton = 2 CONST xlCopy = 1 CONST xlCut = 2 CONST xlFillWithAll = -4104 CONST xlFillWithContents = 2 CONST xlFillWithFormats = -4122 CONST xlFilterCopy = 2 CONST xlFilterInPlace = 1 CONST xlDownThenOver = 1 CONST xlOverThenDown = 2 CONST xlLinkTypeExcelLinks = 1 CONST xlLinkTypeOLELinks = 2 CONST xlColumnThenRow = 2 CONST xlRowThenColumn = 1 CONST xlDisabled = 0 CONST xlErrorHandler = 2 CONST xlInterrupt = 1 CONST xlPageBreakAutomatic = -4105 CONST xlPageBreakManual = -4135 CONST xlPageBreakNone = -4142 CONST xlOLEControl = 2 CONST xlOLEEmbed = 1 CONST xlOLELink = 0 CONST xlLandscape = 2 CONST xlPortrait = 1 CONST xlEditionDate = 2 CONST xlUpdateState = 1 CONST xlLinkInfoStatus = 3 CONST xlCommandUnderlinesAutomatic = -4105 CONST xlCommandUnderlinesOff = -4146 CONST xlCommandUnderlinesOn = 1 CONST xlVerbOpen = 2 CONST xlVerbPrimary = 1 CONST xlCalculationAutomatic = -4105 CONST xlCalculationManual = -4135 CONST xlCalculationSemiautomatic = 2 CONST xlReadOnly = 3 CONST xlReadWrite = 2 CONST xlPublisher = 1 CONST xlSubscriber = 2 CONST xlFitToPage = 2 CONST xlFullPage = 3 CONST xlScreenSize = 1 CONST xlPart = 2 CONST xlWhole = 1 CONST xlMAPI = 1 CONST xlNoMailSystem = 0 CONST xlPowerTalk = 2 CONST xlLinkInfoOLELinks = 2 CONST xlLinkInfoPublishers = 5 CONST xlLinkInfoSubscribers = 6 CONST xlErrDiv0 = 2007 CONST xlErrNA = 2042 CONST xlErrName = 2029 CONST xlErrNull = 2000 CONST xlErrNum = 2036 CONST xlErrRef = 2023 CONST xlErrValue = 2015 CONST xlBIFF = 2 CONST xlPICT = 1 CONST xlRTF = 4 CONST xlVALU = 8 CONST xlExcelLinks = 1 CONST xlOLELinks = 2 CONST xlPublishers = 5 CONST xlSubscribers = 6 CONST xlCellTypeBlanks = 4 CONST xlCellTypeConstants = 2 CONST xlCellTypeFormulas = -4123 CONST xlCellTypeLastCell = 11 CONST xlCellTypeComments = -4144 CONST xlCellTypeVisible = 12 CONST xlCellTypeAllFormatConditions = -4172 CONST xlCellTypeSameFormatConditions = -4173 CONST xlCellTypeAllValidation = -4174 CONST xlCellTypeSameValidation = -4175 CONST xlArrangeStyleCascade = 7 CONST xlArrangeStyleHorizontal = -4128 CONST xlArrangeStyleTiled = 1 CONST xlArrangeStyleVertical = -4166 CONST xlIBeam = 3 CONST xlDefault = -4143 CONST xlNorthwestArrow = 1 CONST xlWait = 2 CONST xlAutomaticUpdate = 4 CONST xlCancel = 1 CONST xlChangeAttributes = 6 CONST xlManualUpdate = 5 CONST xlOpenSource = 3 CONST xlSelect = 3 CONST xlSendPublisher = 2 CONST xlUpdateSubscriber = 2 CONST xlFillCopy = 1 CONST xlFillDays = 5 CONST xlFillDefault = 0 CONST xlFillFormats = 3 CONST xlFillMonths = 7 CONST xlFillSeries = 2 CONST xlFillValues = 4 CONST xlFillWeekdays = 6 CONST xlFillYears = 8 CONST xlGrowthTrend = 10 CONST xlLinearTrend = 9 CONST xlAnd = 1 CONST xlBottom10Items = 4 CONST xlBottom10Percent = 6 CONST xlOr = 2 CONST xlTop10Items = 3 CONST xlTop10Percent = 5 CONST xlClipboardFormatBIFF = 8 CONST xlClipboardFormatBIFF2 = 18 CONST xlClipboardFormatBIFF3 = 20 CONST xlClipboardFormatBIFF4 = 30 CONST xlClipboardFormatBinary = 15 CONST xlClipboardFormatBitmap = 9 CONST xlClipboardFormatCGM = 13 CONST xlClipboardFormatCSV = 5 CONST xlClipboardFormatDIF = 4 CONST xlClipboardFormatDspText = 12 CONST xlClipboardFormatEmbeddedObject = 21 CONST xlClipboardFormatEmbedSource = 22 CONST xlClipboardFormatLink = 11 CONST xlClipboardFormatLinkSource = 23 CONST xlClipboardFormatLinkSourceDesc = 32 CONST xlClipboardFormatMovie = 24 CONST xlClipboardFormatNative = 14 CONST xlClipboardFormatObjectDesc = 31 CONST xlClipboardFormatObjectLink = 19 CONST xlClipboardFormatOwnerLink = 17 CONST xlClipboardFormatPICT = 2 CONST xlClipboardFormatPrintPICT = 3 CONST xlClipboardFormatRTF = 7 CONST xlClipboardFormatScreenPICT = 29 CONST xlClipboardFormatStandardFont = 28 CONST xlClipboardFormatStandardScale = 27 CONST xlClipboardFormatSYLK = 6 CONST xlClipboardFormatTable = 16 CONST xlClipboardFormatText = 0 CONST xlClipboardFormatToolFace = 25 CONST xlClipboardFormatToolFacePICT = 26 CONST xlClipboardFormatVALU = 1 CONST xlClipboardFormatWK1 = 10 CONST xlAddIn = 18 CONST xlCSV = 6 CONST xlCSVMac = 22 CONST xlCSVMSDOS = 24 CONST xlCSVWindows = 23 CONST xlDBF2 = 7 CONST xlDBF3 = 8 CONST xlDBF4 = 11 CONST xlDIF = 9 CONST xlExcel2 = 16 CONST xlExcel2FarEast = 27 CONST xlExcel3 = 29 CONST xlExcel4 = 33 CONST xlExcel5 = 39 CONST xlExcel7 = 39 CONST xlExcel9795 = 43 CONST xlExcel4Workbook = 35 CONST xlIntlAddIn = 26 CONST xlIntlMacro = 25 CONST xlWorkbookNormal = -4143 CONST xlSYLK = 2 CONST xlTemplate = 17 CONST xlCurrentPlatformText = -4158 CONST xlTextMac = 19 CONST xlTextMSDOS = 21 CONST xlTextPrinter = 36 CONST xlTextWindows = 20 CONST xlWJ2WD1 = 14 CONST xlWK1 = 5 CONST xlWK1ALL = 31 CONST xlWK1FMT = 30 CONST xlWK3 = 15 CONST xlWK4 = 38 CONST xlWK3FM3 = 32 CONST xlWKS = 4 CONST xlWorks2FarEast = 28 CONST xlWQ1 = 34 CONST xlWJ3 = 40 CONST xlWJ3FJ3 = 41 CONST xlUnicodeText = 42 CONST xlHtml = 44 CONST xlWebArchive = 45 CONST xlXMLSpreadsheet = 46 CONST xl24HourClock = 33 CONST xl4DigitYears = 43 CONST xlAlternateArraySeparator = 16 CONST xlColumnSeparator = 14 CONST xlCountryCode = 1 CONST xlCountrySetting = 2 CONST xlCurrencyBefore = 37 CONST xlCurrencyCode = 25 CONST xlCurrencyDigits = 27 CONST xlCurrencyLeadingZeros = 40 CONST xlCurrencyMinusSign = 38 CONST xlCurrencyNegative = 28 CONST xlCurrencySpaceBefore = 36 CONST xlCurrencyTrailingZeros = 39 CONST xlDateOrder = 32 CONST xlDateSeparator = 17 CONST xlDayCode = 21 CONST xlDayLeadingZero = 42 CONST xlDecimalSeparator = 3 CONST xlGeneralFormatName = 26 CONST xlHourCode = 22 CONST xlLeftBrace = 12 CONST xlLeftBracket = 10 CONST xlListSeparator = 5 CONST xlLowerCaseColumnLetter = 9 CONST xlLowerCaseRowLetter = 8 CONST xlMDY = 44 CONST xlMetric = 35 CONST xlMinuteCode = 23 CONST xlMonthCode = 20 CONST xlMonthLeadingZero = 41 CONST xlMonthNameChars = 30 CONST xlNoncurrencyDigits = 29 CONST xlNonEnglishFunctions = 34 CONST xlRightBrace = 13 CONST xlRightBracket = 11 CONST xlRowSeparator = 15 CONST xlSecondCode = 24 CONST xlThousandsSeparator = 4 CONST xlTimeLeadingZero = 45 CONST xlTimeSeparator = 18 CONST xlUpperCaseColumnLetter = 7 CONST xlUpperCaseRowLetter = 6 CONST xlWeekdayNameChars = 31 CONST xlYearCode = 19 CONST xlPageBreakFull = 1 CONST xlPageBreakPartial = 2 CONST xlOverwriteCells = 0 CONST xlInsertDeleteCells = 1 CONST xlInsertEntireRows = 2 CONST xlNoLabels = -4142 CONST xlRowLabels = 1 CONST xlColumnLabels = 2 CONST xlMixedLabels = 3 CONST xlSinceMyLastSave = 1 CONST xlAllChanges = 2 CONST xlNotYetReviewed = 3 CONST xlNoIndicator = 0 CONST xlCommentIndicatorOnly = -1 CONST xlCommentAndIndicator = 1 CONST xlCellValue = 1 CONST xlExpression = 2 CONST xlBetween = 1 CONST xlNotBetween = 2 CONST xlEqual = 3 CONST xlNotEqual = 4 CONST xlGreater = 5 CONST xlLess = 6 CONST xlGreaterEqual = 7 CONST xlLessEqual = 8 CONST xlNoRestrictions = 0 CONST xlUnlockedCells = 1 CONST xlNoSelection = -4142 CONST xlValidateInputOnly = 0 CONST xlValidateWholeNumber = 1 CONST xlValidateDecimal = 2 CONST xlValidateList = 3 CONST xlValidateDate = 4 CONST xlValidateTime = 5 CONST xlValidateTextLength = 6 CONST xlValidateCustom = 7 CONST xlIMEModeNoControl = 0 CONST xlIMEModeOn = 1 CONST xlIMEModeOff = 2 CONST xlIMEModeDisable = 3 CONST xlIMEModeHiragana = 4 CONST xlIMEModeKatakana = 5 CONST xlIMEModeKatakanaHalf = 6 CONST xlIMEModeAlphaFull = 7 CONST xlIMEModeAlpha = 8 CONST xlIMEModeHangulFull = 9 CONST xlIMEModeHangul = 10 CONST xlValidAlertStop = 1 CONST xlValidAlertWarning = 2 CONST xlValidAlertInformation = 3 CONST xlLocationAsNewSheet = 1 CONST xlLocationAsObject = 2 CONST xlLocationAutomatic = 3 CONST xlPaper10x14 = 16 CONST xlPaper11x17 = 17 CONST xlPaperA3 = 8 CONST xlPaperA4 = 9 CONST xlPaperA4Small = 10 CONST xlPaperA5 = 11 CONST xlPaperB4 = 12 CONST xlPaperB5 = 13 CONST xlPaperCsheet = 24 CONST xlPaperDsheet = 25 CONST xlPaperEnvelope10 = 20 CONST xlPaperEnvelope11 = 21 CONST xlPaperEnvelope12 = 22 CONST xlPaperEnvelope14 = 23 CONST xlPaperEnvelope9 = 19 CONST xlPaperEnvelopeB4 = 33 CONST xlPaperEnvelopeB5 = 34 CONST xlPaperEnvelopeB6 = 35 CONST xlPaperEnvelopeC3 = 29 CONST xlPaperEnvelopeC4 = 30 CONST xlPaperEnvelopeC5 = 28 CONST xlPaperEnvelopeC6 = 31 CONST xlPaperEnvelopeC65 = 32 CONST xlPaperEnvelopeDL = 27 CONST xlPaperEnvelopeItaly = 36 CONST xlPaperEnvelopeMonarch = 37 CONST xlPaperEnvelopePersonal = 38 CONST xlPaperEsheet = 26 CONST xlPaperExecutive = 7 CONST xlPaperFanfoldLegalGerman = 41 CONST xlPaperFanfoldStdGerman = 40 CONST xlPaperFanfoldUS = 39 CONST xlPaperFolio = 14 CONST xlPaperLedger = 4 CONST xlPaperLegal = 5 CONST xlPaperLetter = 1 CONST xlPaperLetterSmall = 2 CONST xlPaperNote = 18 CONST xlPaperQuarto = 15 CONST xlPaperStatement = 6 CONST xlPaperTabloid = 3 CONST xlPaperUser = 256 CONST xlPasteSpecialOperationAdd = 2 CONST xlPasteSpecialOperationDivide = 5 CONST xlPasteSpecialOperationMultiply = 4 CONST xlPasteSpecialOperationNone = -4142 CONST xlPasteSpecialOperationSubtract = 3 CONST xlPasteAll = -4104 CONST xlPasteAllExceptBorders = 7 CONST xlPasteFormats = -4122 CONST xlPasteFormulas = -4123 CONST xlPasteComments = -4144 CONST xlPasteValues = -4163 CONST xlPasteColumnWidths = 8 CONST xlPasteValidation = 6 CONST xlPasteFormulasAndNumberFormats = 11 CONST xlPasteValuesAndNumberFormats = 12 CONST xlKatakanaHalf = 0 CONST xlKatakana = 1 CONST xlHiragana = 2 CONST xlNoConversion = 3 CONST xlPhoneticAlignNoControl = 0 CONST xlPhoneticAlignLeft = 1 CONST xlPhoneticAlignCenter = 2 CONST xlPhoneticAlignDistributed = 3 CONST xlPrinter = 2 CONST xlScreen = 1 CONST xlColumnField = 2 CONST xlDataField = 4 CONST xlHidden = 0 CONST xlPageField = 3 CONST xlRowField = 1 CONST xlDifferenceFrom = 2 CONST xlIndex = 9 CONST xlNoAdditionalCalculation = -4143 CONST xlPercentDifferenceFrom = 4 CONST xlPercentOf = 3 CONST xlPercentOfColumn = 7 CONST xlPercentOfRow = 6 CONST xlPercentOfTotal = 8 CONST xlRunningTotal = 5 CONST xlFreeFloating = 3 CONST xlMove = 2 CONST xlMoveAndSize = 1 CONST xlMacintosh = 1 CONST xlMSDOS = 3 CONST xlWindows = 2 CONST xlPrintSheetEnd = 1 CONST xlPrintInPlace = 16 CONST xlPrintNoComments = -4142 CONST xlPriorityHigh = -4127 CONST xlPriorityLow = -4134 CONST xlPriorityNormal = -4143 CONST xlLabelOnly = 1 CONST xlDataAndLabel = 0 CONST xlDataOnly = 2 CONST xlOrigin = 3 CONST xlButton = 15 CONST xlBlanks = 4 CONST xlFirstRow = 256 CONST xlRangeAutoFormat3DEffects1 = 13 CONST xlRangeAutoFormat3DEffects2 = 14 CONST xlRangeAutoFormatAccounting1 = 4 CONST xlRangeAutoFormatAccounting2 = 5 CONST xlRangeAutoFormatAccounting3 = 6 CONST xlRangeAutoFormatAccounting4 = 17 CONST xlRangeAutoFormatClassic1 = 1 CONST xlRangeAutoFormatClassic2 = 2 CONST xlRangeAutoFormatClassic3 = 3 CONST xlRangeAutoFormatColor1 = 7 CONST xlRangeAutoFormatColor2 = 8 CONST xlRangeAutoFormatColor3 = 9 CONST xlRangeAutoFormatList1 = 10 CONST xlRangeAutoFormatList2 = 11 CONST xlRangeAutoFormatList3 = 12 CONST xlRangeAutoFormatLocalFormat1 = 15 CONST xlRangeAutoFormatLocalFormat2 = 16 CONST xlRangeAutoFormatLocalFormat3 = 19 CONST xlRangeAutoFormatLocalFormat4 = 20 CONST xlRangeAutoFormatReport1 = 21 CONST xlRangeAutoFormatReport2 = 22 CONST xlRangeAutoFormatReport3 = 23 CONST xlRangeAutoFormatReport4 = 24 CONST xlRangeAutoFormatReport5 = 25 CONST xlRangeAutoFormatReport6 = 26 CONST xlRangeAutoFormatReport7 = 27 CONST xlRangeAutoFormatReport8 = 28 CONST xlRangeAutoFormatReport9 = 29 CONST xlRangeAutoFormatReport10 = 30 CONST xlRangeAutoFormatClassicPivotTable = 31 CONST xlRangeAutoFormatTable1 = 32 CONST xlRangeAutoFormatTable2 = 33 CONST xlRangeAutoFormatTable3 = 34 CONST xlRangeAutoFormatTable4 = 35 CONST xlRangeAutoFormatTable5 = 36 CONST xlRangeAutoFormatTable6 = 37 CONST xlRangeAutoFormatTable7 = 38 CONST xlRangeAutoFormatTable8 = 39 CONST xlRangeAutoFormatTable9 = 40 CONST xlRangeAutoFormatTable10 = 41 CONST xlRangeAutoFormatPTNone = 42 CONST xlRangeAutoFormatNone = -4142 CONST xlRangeAutoFormatSimple = -4154 CONST xlAbsolute = 1 CONST xlAbsRowRelColumn = 2 CONST xlRelative = 4 CONST xlRelRowAbsColumn = 3 CONST xlTabular = 0 CONST xlOutline = 1 CONST xlAllAtOnce = 2 CONST xlOneAfterAnother = 1 CONST xlNotYetRouted = 0 CONST xlRoutingComplete = 2 CONST xlRoutingInProgress = 1 CONST xlAutoActivate = 3 CONST xlAutoClose = 2 CONST xlAutoDeactivate = 4 CONST xlAutoOpen = 1 CONST xlDoNotSaveChanges = 2 CONST xlSaveChanges = 1 CONST xlExclusive = 3 CONST xlNoChange = 1 CONST xlShared = 2 CONST xlLocalSessionChanges = 2 CONST xlOtherSessionChanges = 3 CONST xlUserResolution = 1 CONST xlNext = 1 CONST xlPrevious = 2 CONST xlByColumns = 2 CONST xlByRows = 1 CONST xlSheetVisible = -1 CONST xlSheetHidden = 0 CONST xlSheetVeryHidden = 2 CONST xlPinYin = 1 CONST xlStroke = 2 CONST xlCodePage = 2 CONST xlSyllabary = 1 CONST xlAscending = 1 CONST xlDescending = 2 CONST xlSortRows = 2 CONST xlSortColumns = 1 CONST xlSortLabels = 2 CONST xlSortValues = 1 CONST xlErrors = 16 CONST xlLogical = 4 CONST xlNumbers = 1 CONST xlTextValues = 2 CONST xlSubscribeToPicture = -4147 CONST xlSubscribeToText = -4158 CONST xlSummaryAbove = 0 CONST xlSummaryBelow = 1 CONST xlSummaryOnLeft = -4131 CONST xlSummaryOnRight = -4152 CONST xlSummaryPivotTable = -4148 CONST xlStandardSummary = 1 CONST xlTabPositionFirst = 0 CONST xlTabPositionLast = 1 CONST xlDelimited = 1 CONST xlFixedWidth = 2 CONST xlTextQualifierDoubleQuote = 1 CONST xlTextQualifierNone = -4142 CONST xlTextQualifierSingleQuote = 2 CONST xlWBATChart = -4109 CONST xlWBATExcel4IntlMacroSheet = 4 CONST xlWBATExcel4MacroSheet = 3 CONST xlWBATWorksheet = -4167 CONST xlNormalView = 1 CONST xlPageBreakPreview = 2 CONST xlCommand = 2 CONST xlFunction = 1 CONST xlNotXLM = 3 CONST xlGuess = 0 CONST xlNo = 2 CONST xlYes = 1 CONST xlInsideHorizontal = 12 CONST xlInsideVertical = 11 CONST xlDiagonalDown = 5 CONST xlDiagonalUp = 6 CONST xlEdgeBottom = 9 CONST xlEdgeLeft = 7 CONST xlEdgeRight = 10 CONST xlEdgeTop = 8 CONST xlNoButtonChanges = 1 CONST xlNoChanges = 4 CONST xlNoDockingChanges = 3 CONST xlToolbarProtectionNone = -4143 CONST xlNoShapeChanges = 2 CONST xlDialogOpen = 1 CONST xlDialogOpenLinks = 2 CONST xlDialogSaveAs = 5 CONST xlDialogFileDelete = 6 CONST xlDialogPageSetup = 7 CONST xlDialogPrint = 8 CONST xlDialogPrinterSetup = 9 CONST xlDialogArrangeAll = 12 CONST xlDialogWindowSize = 13 CONST xlDialogWindowMove = 14 CONST xlDialogRun = 17 CONST xlDialogSetPrintTitles = 23 CONST xlDialogFont = 26 CONST xlDialogDisplay = 27 CONST xlDialogProtectDocument = 28 CONST xlDialogCalculation = 32 CONST xlDialogExtract = 35 CONST xlDialogDataDelete = 36 CONST xlDialogSort = 39 CONST xlDialogDataSeries = 40 CONST xlDialogTable = 41 CONST xlDialogFormatNumber = 42 CONST xlDialogAlignment = 43 CONST xlDialogStyle = 44 CONST xlDialogBorder = 45 CONST xlDialogCellProtection = 46 CONST xlDialogColumnWidth = 47 CONST xlDialogClear = 52 CONST xlDialogPasteSpecial = 53 CONST xlDialogEditDelete = 54 CONST xlDialogInsert = 55 CONST xlDialogPasteNames = 58 CONST xlDialogDefineName = 61 CONST xlDialogCreateNames = 62 CONST xlDialogFormulaGoto = 63 CONST xlDialogFormulaFind = 64 CONST xlDialogGalleryArea = 67 CONST xlDialogGalleryBar = 68 CONST xlDialogGalleryColumn = 69 CONST xlDialogGalleryLine = 70 CONST xlDialogGalleryPie = 71 CONST xlDialogGalleryScatter = 72 CONST xlDialogCombination = 73 CONST xlDialogGridlines = 76 CONST xlDialogAxes = 78 CONST xlDialogAttachText = 80 CONST xlDialogPatterns = 84 CONST xlDialogMainChart = 85 CONST xlDialogOverlay = 86 CONST xlDialogScale = 87 CONST xlDialogFormatLegend = 88 CONST xlDialogFormatText = 89 CONST xlDialogParse = 91 CONST xlDialogUnhide = 94 CONST xlDialogWorkspace = 95 CONST xlDialogActivate = 103 CONST xlDialogCopyPicture = 108 CONST xlDialogDeleteName = 110 CONST xlDialogDeleteFormat = 111 CONST xlDialogNew = 119 CONST xlDialogRowHeight = 127 CONST xlDialogFormatMove = 128 CONST xlDialogFormatSize = 129 CONST xlDialogFormulaReplace = 130 CONST xlDialogSelectSpecial = 132 CONST xlDialogApplyNames = 133 CONST xlDialogReplaceFont = 134 CONST xlDialogSplit = 137 CONST xlDialogOutline = 142 CONST xlDialogSaveWorkbook = 145 CONST xlDialogCopyChart = 147 CONST xlDialogFormatFont = 150 CONST xlDialogNote = 154 CONST xlDialogSetUpdateStatus = 159 CONST xlDialogColorPalette = 161 CONST xlDialogChangeLink = 166 CONST xlDialogAppMove = 170 CONST xlDialogAppSize = 171 CONST xlDialogMainChartType = 185 CONST xlDialogOverlayChartType = 186 CONST xlDialogOpenMail = 188 CONST xlDialogSendMail = 189 CONST xlDialogStandardFont = 190 CONST xlDialogConsolidate = 191 CONST xlDialogSortSpecial = 192 CONST xlDialogGallery3dArea = 193 CONST xlDialogGallery3dColumn = 194 CONST xlDialogGallery3dLine = 195 CONST xlDialogGallery3dPie = 196 CONST xlDialogView3d = 197 CONST xlDialogGoalSeek = 198 CONST xlDialogWorkgroup = 199 CONST xlDialogFillGroup = 200 CONST xlDialogUpdateLink = 201 CONST xlDialogPromote = 202 CONST xlDialogDemote = 203 CONST xlDialogShowDetail = 204 CONST xlDialogObjectProperties = 207 CONST xlDialogSaveNewObject = 208 CONST xlDialogApplyStyle = 212 CONST xlDialogAssignToObject = 213 CONST xlDialogObjectProtection = 214 CONST xlDialogCreatePublisher = 217 CONST xlDialogSubscribeTo = 218 CONST xlDialogShowToolbar = 220 CONST xlDialogPrintPreview = 222 CONST xlDialogEditColor = 223 CONST xlDialogFormatMain = 225 CONST xlDialogFormatOverlay = 226 CONST xlDialogEditSeries = 228 CONST xlDialogDefineStyle = 229 CONST xlDialogGalleryRadar = 249 CONST xlDialogEditionOptions = 251 CONST xlDialogZoom = 256 CONST xlDialogInsertObject = 259 CONST xlDialogSize = 261 CONST xlDialogMove = 262 CONST xlDialogFormatAuto = 269 CONST xlDialogGallery3dBar = 272 CONST xlDialogGallery3dSurface = 273 CONST xlDialogCustomizeToolbar = 276 CONST xlDialogWorkbookAdd = 281 CONST xlDialogWorkbookMove = 282 CONST xlDialogWorkbookCopy = 283 CONST xlDialogWorkbookOptions = 284 CONST xlDialogSaveWorkspace = 285 CONST xlDialogChartWizard = 288 CONST xlDialogAssignToTool = 293 CONST xlDialogPlacement = 300 CONST xlDialogFillWorkgroup = 301 CONST xlDialogWorkbookNew = 302 CONST xlDialogScenarioCells = 305 CONST xlDialogScenarioAdd = 307 CONST xlDialogScenarioEdit = 308 CONST xlDialogScenarioSummary = 311 CONST xlDialogPivotTableWizard = 312 CONST xlDialogPivotFieldProperties = 313 CONST xlDialogOptionsCalculation = 318 CONST xlDialogOptionsEdit = 319 CONST xlDialogOptionsView = 320 CONST xlDialogAddinManager = 321 CONST xlDialogMenuEditor = 322 CONST xlDialogAttachToolbars = 323 CONST xlDialogOptionsChart = 325 CONST xlDialogVbaInsertFile = 328 CONST xlDialogVbaProcedureDefinition = 330 CONST xlDialogRoutingSlip = 336 CONST xlDialogMailLogon = 339 CONST xlDialogInsertPicture = 342 CONST xlDialogGalleryDoughnut = 344 CONST xlDialogChartTrend = 350 CONST xlDialogWorkbookInsert = 354 CONST xlDialogOptionsTransition = 355 CONST xlDialogOptionsGeneral = 356 CONST xlDialogFilterAdvanced = 370 CONST xlDialogMailNextLetter = 378 CONST xlDialogDataLabel = 379 CONST xlDialogInsertTitle = 380 CONST xlDialogFontProperties = 381 CONST xlDialogMacroOptions = 382 CONST xlDialogWorkbookUnhide = 384 CONST xlDialogWorkbookName = 386 CONST xlDialogGalleryCustom = 388 CONST xlDialogAddChartAutoformat = 390 CONST xlDialogChartAddData = 392 CONST xlDialogTabOrder = 394 CONST xlDialogSubtotalCreate = 398 CONST xlDialogWorkbookTabSplit = 415 CONST xlDialogWorkbookProtect = 417 CONST xlDialogScrollbarProperties = 420 CONST xlDialogPivotShowPages = 421 CONST xlDialogTextToColumns = 422 CONST xlDialogFormatCharttype = 423 CONST xlDialogPivotFieldGroup = 433 CONST xlDialogPivotFieldUngroup = 434 CONST xlDialogCheckboxProperties = 435 CONST xlDialogLabelProperties = 436 CONST xlDialogListboxProperties = 437 CONST xlDialogEditboxProperties = 438 CONST xlDialogOpenText = 441 CONST xlDialogPushbuttonProperties = 445 CONST xlDialogFilter = 447 CONST xlDialogFunctionWizard = 450 CONST xlDialogSaveCopyAs = 456 CONST xlDialogOptionsListsAdd = 458 CONST xlDialogSeriesAxes = 460 CONST xlDialogSeriesX = 461 CONST xlDialogSeriesY = 462 CONST xlDialogErrorbarX = 463 CONST xlDialogErrorbarY = 464 CONST xlDialogFormatChart = 465 CONST xlDialogSeriesOrder = 466 CONST xlDialogMailEditMailer = 470 CONST xlDialogStandardWidth = 472 CONST xlDialogScenarioMerge = 473 CONST xlDialogProperties = 474 CONST xlDialogSummaryInfo = 474 CONST xlDialogFindFile = 475 CONST xlDialogActiveCellFont = 476 CONST xlDialogVbaMakeAddin = 478 CONST xlDialogFileSharing = 481 CONST xlDialogAutoCorrect = 485 CONST xlDialogCustomViews = 493 CONST xlDialogInsertNameLabel = 496 CONST xlDialogSeriesShape = 504 CONST xlDialogChartOptionsDataLabels = 505 CONST xlDialogChartOptionsDataTable = 506 CONST xlDialogSetBackgroundPicture = 509 CONST xlDialogDataValidation = 525 CONST xlDialogChartType = 526 CONST xlDialogChartLocation = 527 CONST _xlDialogPhonetic = 538 CONST xlDialogChartSourceData = 540 CONST _xlDialogChartSourceData = 541 CONST xlDialogSeriesOptions = 557 CONST xlDialogPivotTableOptions = 567 CONST xlDialogPivotSolveOrder = 568 CONST xlDialogPivotCalculatedField = 570 CONST xlDialogPivotCalculatedItem = 572 CONST xlDialogConditionalFormatting = 583 CONST xlDialogInsertHyperlink = 596 CONST xlDialogProtectSharing = 620 CONST xlDialogOptionsME = 647 CONST xlDialogPublishAsWebPage = 653 CONST xlDialogPhonetic = 656 CONST xlDialogNewWebQuery = 667 CONST xlDialogImportTextFile = 666 CONST xlDialogExternalDataProperties = 530 CONST xlDialogWebOptionsGeneral = 683 CONST xlDialogWebOptionsFiles = 684 CONST xlDialogWebOptionsPictures = 685 CONST xlDialogWebOptionsEncoding = 686 CONST xlDialogWebOptionsFonts = 687 CONST xlDialogPivotClientServerSet = 689 CONST xlDialogPropertyFields = 754 CONST xlDialogSearch = 731 CONST xlDialogEvaluateFormula = 709 CONST xlDialogDataLabelMultiple = 723 CONST xlDialogChartOptionsDataLabelMultiple = 724 CONST xlDialogErrorChecking = 732 CONST xlDialogWebOptionsBrowsers = 773 CONST xlDialogCreateList = 796 CONST xlDialogPermission = 832 CONST xlDialogMyPermission = 834 CONST xlPrompt = 0 CONST xlConstant = 1 CONST xlRange = 2 CONST xlParamTypeUnknown = 0 CONST xlParamTypeChar = 1 CONST xlParamTypeNumeric = 2 CONST xlParamTypeDecimal = 3 CONST xlParamTypeInteger = 4 CONST xlParamTypeSmallInt = 5 CONST xlParamTypeFloat = 6 CONST xlParamTypeReal = 7 CONST xlParamTypeDouble = 8 CONST xlParamTypeVarChar = 12 CONST xlParamTypeDate = 9 CONST xlParamTypeTime = 10 CONST xlParamTypeTimestamp = 11 CONST xlParamTypeLongVarChar = -1 CONST xlParamTypeBinary = -2 CONST xlParamTypeVarBinary = -3 CONST xlParamTypeLongVarBinary = -4 CONST xlParamTypeBigInt = -5 CONST xlParamTypeTinyInt = -6 CONST xlParamTypeBit = -7 CONST xlParamTypeWChar = -8 CONST xlButtonControl = 0 CONST xlCheckBox = 1 CONST xlDropDown = 2 CONST xlEditBox = 3 CONST xlGroupBox = 4 CONST xlLabel = 5 CONST xlListBox = 6 CONST xlOptionButton = 7 CONST xlScrollBar = 8 CONST xlSpinner = 9 CONST xlSourceWorkbook = 0 CONST xlSourceSheet = 1 CONST xlSourcePrintArea = 2 CONST xlSourceAutoFilter = 3 CONST xlSourceRange = 4 CONST xlSourceChart = 5 CONST xlSourcePivotTable = 6 CONST xlSourceQuery = 7 CONST xlHtmlStatic = 0 CONST xlHtmlCalc = 1 CONST xlHtmlList = 2 CONST xlHtmlChart = 3 CONST xlReport1 = 0 CONST xlReport2 = 1 CONST xlReport3 = 2 CONST xlReport4 = 3 CONST xlReport5 = 4 CONST xlReport6 = 5 CONST xlReport7 = 6 CONST xlReport8 = 7 CONST xlReport9 = 8 CONST xlReport10 = 9 CONST xlTable1 = 10 CONST xlTable2 = 11 CONST xlTable3 = 12 CONST xlTable4 = 13 CONST xlTable5 = 14 CONST xlTable6 = 15 CONST xlTable7 = 16 CONST xlTable8 = 17 CONST xlTable9 = 18 CONST xlTable10 = 19 CONST xlPTClassic = 20 CONST xlPTNone = 21 CONST xlCmdCube = 1 CONST xlCmdSql = 2 CONST xlCmdTable = 3 CONST xlCmdDefault = 4 CONST xlCmdList = 5 CONST xlGeneralFormat = 1 CONST xlTextFormat = 2 CONST xlMDYFormat = 3 CONST xlDMYFormat = 4 CONST xlYMDFormat = 5 CONST xlMYDFormat = 6 CONST xlDYMFormat = 7 CONST xlYDMFormat = 8 CONST xlSkipColumn = 9 CONST xlEMDFormat = 10 CONST xlODBCQuery = 1 CONST xlDAORecordset = 2 CONST xlWebQuery = 4 CONST xlOLEDBQuery = 5 CONST xlTextImport = 6 CONST xlADORecordset = 7 CONST xlEntirePage = 1 CONST xlAllTables = 2 CONST xlSpecifiedTables = 3 CONST xlHierarchy = 1 CONST xlMeasure = 2 CONST xlSet = 3 CONST xlWebFormattingAll = 1 CONST xlWebFormattingRTF = 2 CONST xlWebFormattingNone = 3 CONST xlDisplayShapes = -4104 CONST xlHide = 3 CONST xlPlaceholders = 2 CONST xlAtTop = 1 CONST xlAtBottom = 2 CONST xlPivotTableVersion2000 = 0 CONST xlPivotTableVersion10 = 1 CONST xlPivotTableVersionCurrent = -1 CONST xlPrintErrorsDisplayed = 0 CONST xlPrintErrorsBlank = 1 CONST xlPrintErrorsDash = 2 CONST xlPrintErrorsNA = 3 CONST xlPivotCellValue = 0 CONST xlPivotCellPivotItem = 1 CONST xlPivotCellSubtotal = 2 CONST xlPivotCellGrandTotal = 3 CONST xlPivotCellDataField = 4 CONST xlPivotCellPivotField = 5 CONST xlPivotCellPageFieldItem = 6 CONST xlPivotCellCustomSubtotal = 7 CONST xlPivotCellDataPivotField = 8 CONST xlPivotCellBlankCell = 9 CONST xlMissingItemsDefault = -1 CONST xlMissingItemsNone = 0 CONST xlMissingItemsMax = 32500 CONST xlDone = 0 CONST xlCalculating = 1 CONST xlPending = 2 CONST xlNoKey = 0 CONST xlEscKey = 1 CONST xlAnyKey = 2 CONST xlSortNormal = 0 CONST xlSortTextAsNumbers = 1 CONST xlUpdateLinksUserSetting = 1 CONST xlUpdateLinksNever = 2 CONST xlUpdateLinksAlways = 3 CONST xlLinkStatusOK = 0 CONST xlLinkStatusMissingFile = 1 CONST xlLinkStatusMissingSheet = 2 CONST xlLinkStatusOld = 3 CONST xlLinkStatusSourceNotCalculated = 4 CONST xlLinkStatusIndeterminate = 5 CONST xlLinkStatusNotStarted = 6 CONST xlLinkStatusInvalidName = 7 CONST xlLinkStatusSourceNotOpen = 8 CONST xlLinkStatusSourceOpen = 9 CONST xlLinkStatusCopiedValues = 10 CONST xlWithinSheet = 1 CONST xlWithinWorkbook = 2 CONST xlNormalLoad = 0 CONST xlRepairFile = 1 CONST xlExtractData = 2 CONST xlAsRequired = 0 CONST xlAlways = 1 CONST xlNever = 2 CONST xlEvaluateToError = 1 CONST xlTextDate = 2 CONST xlNumberAsText = 3 CONST xlInconsistentFormula = 4 CONST xlOmittedCells = 5 CONST xlUnlockedFormulaCells = 6 CONST xlEmptyCellReferences = 7 CONST xlListDataValidation = 8 CONST xlDataLabelSeparatorDefault = 1 CONST xlIndicatorAndButton = 0 CONST xlDisplayNone = 1 CONST xlButtonOnly = 2 CONST xlRangeValueDefault = 10 CONST xlRangeValueXMLSpreadsheet = 11 CONST xlRangeValueMSPersistXML = 12 CONST xlSpeakByRows = 0 CONST xlSpeakByColumns = 1 CONST xlFormatFromLeftOrAbove = 0 CONST xlFormatFromRightOrBelow = 1 CONST xlArabicNone = 0 CONST xlArabicStrictAlefHamza = 1 CONST xlArabicStrictFinalYaa = 2 CONST xlArabicBothStrict = 3 CONST xlQueryTable = 0 CONST xlPivotTableReport = 1 CONST xlCalculatedMember = 0 CONST xlCalculatedSet = 1 CONST xlHebrewFullScript = 0 CONST xlHebrewPartialScript = 1 CONST xlHebrewMixedScript = 2 CONST xlHebrewMixedAuthorizedScript = 3 CONST xlSrcExternal = 0 CONST xlSrcRange = 1 CONST xlSrcXml = 2 CONST xlTextVisualLTR = 1 CONST xlTextVisualRTL = 2 CONST xlListDataTypeNone = 0 CONST xlListDataTypeText = 1 CONST xlListDataTypeMultiLineText = 2 CONST xlListDataTypeNumber = 3 CONST xlListDataTypeCurrency = 4 CONST xlListDataTypeDateTime = 5 CONST xlListDataTypeChoice = 6 CONST xlListDataTypeChoiceMulti = 7 CONST xlListDataTypeListLookup = 8 CONST xlListDataTypeCheckbox = 9 CONST xlListDataTypeHyperLink = 10 CONST xlListDataTypeCounter = 11 CONST xlListDataTypeMultiLineRichText = 12 CONST xlTotalsCalculationNone = 0 CONST xlTotalsCalculationSum = 1 CONST xlTotalsCalculationAverage = 2 CONST xlTotalsCalculationCount = 3 CONST xlTotalsCalculationCountNums = 4 CONST xlTotalsCalculationMin = 5 CONST xlTotalsCalculationMax = 6 CONST xlTotalsCalculationStdDev = 7 CONST xlTotalsCalculationVar = 8 CONST xlXmlLoadPromptUser = 0 CONST xlXmlLoadOpenXml = 1 CONST xlXmlLoadImportToList = 2 CONST xlXmlLoadMapXml = 3 CONST xlSmartTagControlSmartTag = 1 CONST xlSmartTagControlLink = 2 CONST xlSmartTagControlHelp = 3 CONST xlSmartTagControlHelpURL = 4 CONST xlSmartTagControlSeparator = 5 CONST xlSmartTagControlButton = 6 CONST xlSmartTagControlLabel = 7 CONST xlSmartTagControlImage = 8 CONST xlSmartTagControlCheckbox = 9 CONST xlSmartTagControlTextbox = 10 CONST xlSmartTagControlListbox = 11 CONST xlSmartTagControlCombo = 12 CONST xlSmartTagControlActiveX = 13 CONST xlSmartTagControlRadioGroup = 14 CONST xlListConflictDialog = 0 CONST xlListConflictRetryAllConflicts = 1 CONST xlListConflictDiscardAllConflicts = 2 CONST xlListConflictError = 3 CONST xlXmlExportSuccess = 0 CONST xlXmlExportValidationFailed = 1 CONST xlXmlImportSuccess = 0 CONST xlXmlImportElementsTruncated = 1 CONST xlXmlImportValidationFailed = 2 Script execution has completed |
Hi.. Could you please run again your script to update this list ?