Microsoft Excel Constants

Microsoft Excel Visual Basic

Show All Show All

Microsoft Excel Constants

This topic lists all constants in the Microsoft Excel object model.

Show XlApplicationInternational

Constant Value
xl24HourClock 33
xl4DigitYears 43
xlAlternateArraySeparator 16
xlColumnSeparator 14
xlCountryCode 1
xlCountrySetting 2
xlCurrencyBefore 37
xlCurrencyCode 25
xlCurrencyDigits 27
xlCurrencyLeadingZeros 40
xlCurrencyMinusSign 38
xlCurrencyNegative 28
xlCurrencySpaceBefore 36
xlCurrencyTrailingZeros 39
xlDateOrder 32
xlDateSeparator 17
xlDayCode 21
xlDayLeadingZero 42
xlDecimalSeparator 3
xlGeneralFormatName 26
xlHourCode 22
xlLeftBrace 12
xlLeftBracket 10
xlListSeparator 5
xlLowerCaseColumnLetter 9
xlLowerCaseRowLetter 8
xlMDY 44
xlMetric 35
xlMinuteCode 23
xlMonthCode 20
xlMonthLeadingZero 41
xlMonthNameChars 30
xlNoncurrencyDigits 29
xlNonEnglishFunctions 34
xlRightBrace 13
xlRightBracket 11
xlRowSeparator 15
xlSecondCode 24
xlThousandsSeparator 4
xlTimeLeadingZero 45
xlTimeSeparator 18
xlUpperCaseColumnLetter 7
xlUpperCaseRowLetter 6
xlWeekdayNameChars 31
xlYearCode 19

Show XlApplyNamesOrder

Constant Value
xlColumnThenRow 2
xlRowThenColumn 1

Show XlArabicModes

Constant Value
xlArabicBothStrict 3
xlArabicNone 0
xlArabicStrictAlefHamza 1
xlArabicStrictFinalYaa 2

Show XlArrangeStyle

Constant Value
xlArrangeStyleCascade 7
xlArrangeStyleHorizontal -4128
xlArrangeStyleTiled 1
xlArrangeStyleVertical -4166

Show XlArrowHeadLength

Constant Value
xlArrowHeadLengthLong 3
xlArrowHeadLengthMedium -4138
xlArrowHeadLengthShort 1

Show XlArrowHeadStyle

Constant Value
xlArrowHeadStyleClosed 3
xlArrowHeadStyleDoubleClosed 5
xlArrowHeadStyleDoubleOpen 4
xlArrowHeadStyleNone -4142
xlArrowHeadStyleOpen 2

Show XlArrowHeadWidth

Constant Value
xlArrowHeadWidthMedium -4138
xlArrowHeadWidthNarrow 1
xlArrowHeadWidthWide 3

Show XlAutoFillType

Constant Value
xlFillCopy 1
xlFillDays 5
xlFillDefault 0
xlFillFormats 3
xlFillMonths 7
xlFillSeries 2
xlFillValues 4
xlFillWeekdays 6
xlFillYears 8
xlGrowthTrend 10
xlLinearTrend 9

Show XlAutoFilterOperator

Constant Value
xlAnd 1
xlBottom10Items 4
xlBottom10Percent 6
xlOr 2
xlTop10Items 3
xlTop10Percent 5

Show XlAxisCrosses

Constant Value
xlAxisCrossesAutomatic -4105
xlAxisCrossesCustom -4114
xlAxisCrossesMaximum 2
xlAxisCrossesMinimum 4

Show XlAxisGroup

Constant Value
xlPrimary 1
xlSecondary 2

Show XlAxisType

Constant Value
xlCategory 1
xlSeriesAxis 3
xlValue 2

Show XlBackground

Constant Value
xlBackgroundAutomatic -4105
xlBackgroundOpaque 3
xlBackgroundTransparent 2

Show XlBarShape

Constant Value
xlBox 0
xlConeToMax 5
xlConeToPoint 4
xlCylinder 3
xlPyramidToMax 2
xlPyramidToPoint 1

Show XlBordersIndex

Constant Value
xlDiagonalDown 5
xlDiagonalUp 6
xlEdgeBottom 9
xlEdgeLeft 7
xlEdgeRight 10
xlEdgeTop 8
xlInsideHorizontal 12
xlInsideVertical 11

Show XlBorderWeight

Constant Value
xlHairline 1
xlMedium -4138
xlThick 4
xlThin 2

Show XlBuiltInDialog

Constant Value
_xlDialogChartSourceData 541
_xlDialogPhonetic 538
xlDialogActivate 103
xlDialogActiveCellFont 476
xlDialogAddChartAutoformat 390
xlDialogAddinManager 321
xlDialogAlignment 43
xlDialogApplyNames 133
xlDialogApplyStyle 212
xlDialogAppMove 170
xlDialogAppSize 171
xlDialogArrangeAll 12
xlDialogAssignToObject 213
xlDialogAssignToTool 293
xlDialogAttachText 80
xlDialogAttachToolbars 323
xlDialogAutoCorrect 485
xlDialogAxes 78
xlDialogBorder 45
xlDialogCalculation 32
xlDialogCellProtection 46
xlDialogChangeLink 166
xlDialogChartAddData 392
xlDialogChartLocation 527
xlDialogChartOptionsDataLabelMultiple 724
xlDialogChartOptionsDataLabels 505
xlDialogChartOptionsDataTable 506
xlDialogChartSourceData 540
xlDialogChartTrend 350
xlDialogChartType 526
xlDialogChartWizard 288
xlDialogCheckboxProperties 435
xlDialogClear 52
xlDialogColorPalette 161
xlDialogColumnWidth 47
xlDialogCombination 73
xlDialogConditionalFormatting 583
xlDialogConsolidate 191
xlDialogCopyChart 147
xlDialogCopyPicture 108
xlDialogCreateList 796
xlDialogCreateNames 62
xlDialogCreatePublisher 217
xlDialogCustomizeToolbar 276
xlDialogCustomViews 493
xlDialogDataDelete 36
xlDialogDataLabel 379
xlDialogDataLabelMultiple 723
xlDialogDataSeries 40
xlDialogDataValidation 525
xlDialogDefineName 61
xlDialogDefineStyle 229
xlDialogDeleteFormat 111
xlDialogDeleteName 110
xlDialogDemote 203
xlDialogDisplay 27
xlDialogEditboxProperties 438
xlDialogEditColor 223
xlDialogEditDelete 54
xlDialogEditionOptions 251
xlDialogEditSeries 228
xlDialogErrorbarX 463
xlDialogErrorbarY 464
xlDialogErrorChecking 732
xlDialogEvaluateFormula 709
xlDialogExternalDataProperties 530
xlDialogExtract 35
xlDialogFileDelete 6
xlDialogFileSharing 481
xlDialogFillGroup 200
xlDialogFillWorkgroup 301
xlDialogFilter 447
xlDialogFilterAdvanced 370
xlDialogFindFile 475
xlDialogFont 26
xlDialogFontProperties 381
xlDialogFormatAuto 269
xlDialogFormatChart 465
xlDialogFormatCharttype 423
xlDialogFormatFont 150
xlDialogFormatLegend 88
xlDialogFormatMain 225
xlDialogFormatMove 128
xlDialogFormatNumber 42
xlDialogFormatOverlay 226
xlDialogFormatSize 129
xlDialogFormatText 89
xlDialogFormulaFind 64
xlDialogFormulaGoto 63
xlDialogFormulaReplace 130
xlDialogFunctionWizard 450
xlDialogGallery3dArea 193
xlDialogGallery3dBar 272
xlDialogGallery3dColumn 194
xlDialogGallery3dLine 195
xlDialogGallery3dPie 196
xlDialogGallery3dSurface 273
xlDialogGalleryArea 67
xlDialogGalleryBar 68
xlDialogGalleryColumn 69
xlDialogGalleryCustom 388
xlDialogGalleryDoughnut 344
xlDialogGalleryLine 70
xlDialogGalleryPie 71
xlDialogGalleryRadar 249
xlDialogGalleryScatter 72
xlDialogGoalSeek 198
xlDialogGridlines 76
xlDialogImportTextFile 666
xlDialogInsert 55
xlDialogInsertHyperlink 596
xlDialogInsertNameLabel 496
xlDialogInsertObject 259
xlDialogInsertPicture 342
xlDialogInsertTitle 380
xlDialogLabelProperties 436
xlDialogListboxProperties 437
xlDialogMacroOptions 382
xlDialogMailEditMailer 470
xlDialogMailLogon 339
xlDialogMailNextLetter 378
xlDialogMainChart 85
xlDialogMainChartType 185
xlDialogMenuEditor 322
xlDialogMove 262
xlDialogMyPermission 834
xlDialogNew 119
xlDialogNewWebQuery 667
xlDialogNote 154
xlDialogObjectProperties 207
xlDialogObjectProtection 214
xlDialogOpen 1
xlDialogOpenLinks 2
xlDialogOpenMail 188
xlDialogOpenText 441
xlDialogOptionsCalculation 318
xlDialogOptionsChart 325
xlDialogOptionsEdit 319
xlDialogOptionsGeneral 356
xlDialogOptionsListsAdd 458
xlDialogOptionsME 647
xlDialogOptionsTransition 355
xlDialogOptionsView 320
xlDialogOutline 142
xlDialogOverlay 86
xlDialogOverlayChartType 186
xlDialogPageSetup 7
xlDialogParse 91
xlDialogPasteNames 58
xlDialogPasteSpecial 53
xlDialogPatterns 84
xlDialogPermission 832
xlDialogPhonetic 656
xlDialogPivotCalculatedField 570
xlDialogPivotCalculatedItem 572
xlDialogPivotClientServerSet 689
xlDialogPivotFieldGroup 433
xlDialogPivotFieldProperties 313
xlDialogPivotFieldUngroup 434
xlDialogPivotShowPages 421
xlDialogPivotSolveOrder 568
xlDialogPivotTableOptions 567
xlDialogPivotTableWizard 312
xlDialogPlacement 300
xlDialogPrint 8
xlDialogPrinterSetup 9
xlDialogPrintPreview 222
xlDialogPromote 202
xlDialogProperties 474
xlDialogPropertyFields 754
xlDialogProtectDocument 28
xlDialogProtectSharing 620
xlDialogPublishAsWebPage 653
xlDialogPushbuttonProperties 445
xlDialogReplaceFont 134
xlDialogRoutingSlip 336
xlDialogRowHeight 127
xlDialogRun 17
xlDialogSaveAs 5
xlDialogSaveCopyAs 456
xlDialogSaveNewObject 208
xlDialogSaveWorkbook 145
xlDialogSaveWorkspace 285
xlDialogScale 87
xlDialogScenarioAdd 307
xlDialogScenarioCells 305
xlDialogScenarioEdit 308
xlDialogScenarioMerge 473
xlDialogScenarioSummary 311
xlDialogScrollbarProperties 420
xlDialogSearch 731
xlDialogSelectSpecial 132
xlDialogSendMail 189
xlDialogSeriesAxes 460
xlDialogSeriesOptions 557
xlDialogSeriesOrder 466
xlDialogSeriesShape 504
xlDialogSeriesX 461
xlDialogSeriesY 462
xlDialogSetBackgroundPicture 509
xlDialogSetPrintTitles 23
xlDialogSetUpdateStatus 159
xlDialogShowDetail 204
xlDialogShowToolbar 220
xlDialogSize 261
xlDialogSort 39
xlDialogSortSpecial 192
xlDialogSplit 137
xlDialogStandardFont 190
xlDialogStandardWidth 472
xlDialogStyle 44
xlDialogSubscribeTo 218
xlDialogSubtotalCreate 398
xlDialogSummaryInfo 474
xlDialogTable 41
xlDialogTabOrder 394
xlDialogTextToColumns 422
xlDialogUnhide 94
xlDialogUpdateLink 201
xlDialogVbaInsertFile 328
xlDialogVbaMakeAddin 478
xlDialogVbaProcedureDefinition 330
xlDialogView3d 197
xlDialogWebOptionsBrowsers 773
xlDialogWebOptionsEncoding 686
xlDialogWebOptionsFiles 684
xlDialogWebOptionsFonts 687
xlDialogWebOptionsGeneral 683
xlDialogWebOptionsPictures 685
xlDialogWindowMove 14
xlDialogWindowSize 13
xlDialogWorkbookAdd 281
xlDialogWorkbookCopy 283
xlDialogWorkbookInsert 354
xlDialogWorkbookMove 282
xlDialogWorkbookName 386
xlDialogWorkbookNew 302
xlDialogWorkbookOptions 284
xlDialogWorkbookProtect 417
xlDialogWorkbookTabSplit 415
xlDialogWorkbookUnhide 384
xlDialogWorkgroup 199
xlDialogWorkspace 95
xlDialogZoom 256

Show XlCalculatedMemberType

Constant Value
xlCalculatedMember 0
xlCalculatedSet 1

Show XlCalculation

Constant Value
xlCalculationAutomatic -4105
xlCalculationManual -4135
xlCalculationSemiautomatic 2

Show XlCalculationInterruptKey

Constant Value
xlAnyKey 2
xlEscKey 1
xlNoKey 0

Show XlCalculationState

Constant Value
xlCalculating 1
xlDone 0
xlPending 2

Show XlCategoryType

Constant Value
xlAutomaticScale -4105
xlCategoryScale 2
xlTimeScale 3

Show XlCellInsertionMode

Constant Value
xlInsertDeleteCells 1
xlInsertEntireRows 2
xlOverwriteCells 0

Show XlCellType

Constant Value
xlCellTypeAllFormatConditions -4172
xlCellTypeAllValidation -4174
xlCellTypeBlanks 4
xlCellTypeComments -4144
xlCellTypeConstants 2
xlCellTypeFormulas -4123
xlCellTypeLastCell 11
xlCellTypeSameFormatConditions -4173
xlCellTypeSameValidation -4175
xlCellTypeVisible 12

Show XlChartGallery

Constant Value
xlAnyGallery 23
xlBuiltIn 21
xlUserDefined 22

Show XlChartItem

Constant Value
xlAxis 21
xlAxisTitle 17
xlChartArea 2
xlChartTitle 4
xlCorners 6
xlDataLabel 0
xlDataTable 7
xlDisplayUnitLabel 30
xlDownBars 20
xlDropLines 26
xlErrorBars 9
xlFloor 23
xlHiLoLines 25
xlLeaderLines 29
xlLegend 24
xlLegendEntry 12
xlLegendKey 13
xlMajorGridlines 15
xlMinorGridlines 16
xlNothing 28
xlPivotChartDropZone 32
xlPivotChartFieldButton 31
xlPlotArea 19
xlRadarAxisLabels 27
xlSeries 3
xlSeriesLines 22
xlShape 14
xlTrendline 8
xlUpBars 18
xlWalls 5
xlXErrorBars 10
xlYErrorBars 11

Show XlChartLocation

Constant Value
xlLocationAsNewSheet 1
xlLocationAsObject 2
xlLocationAutomatic 3

Show XlChartPicturePlacement

Constant Value
xlAllFaces 7
xlEnd 2
xlEndSides 3
xlFront 4
xlFrontEnd 6
xlFrontSides 5
xlSides 1

Show XlChartPictureType

Constant Value
xlStack 2
xlStackScale 3
xlStretch 1

Show XlChartSplitType

Constant Value
xlSplitByCustomSplit 4
xlSplitByPercentValue 3
xlSplitByPosition 1
xlSplitByValue 2

Show XlChartType

Constant Value
xl3DArea -4098
xl3DAreaStacked 78
xl3DAreaStacked100 79
xl3DBarClustered 60
xl3DBarStacked 61
xl3DBarStacked100 62
xl3DColumn -4100
xl3DColumnClustered 54
xl3DColumnStacked 55
xl3DColumnStacked100 56
xl3DLine -4101
xl3DPie -4102
xl3DPieExploded 70
xlArea 1
xlAreaStacked 76
xlAreaStacked100 77
xlBarClustered 57
xlBarOfPie 71
xlBarStacked 58
xlBarStacked100 59
xlBubble 15
xlBubble3DEffect 87
xlColumnClustered 51
xlColumnStacked 52
xlColumnStacked100 53
xlConeBarClustered 102
xlConeBarStacked 103
xlConeBarStacked100 104
xlConeCol 105
xlConeColClustered 99
xlConeColStacked 100
xlConeColStacked100 101
xlCylinderBarClustered 95
xlCylinderBarStacked 96
xlCylinderBarStacked100 97
xlCylinderCol 98
xlCylinderColClustered 92
xlCylinderColStacked 93
xlCylinderColStacked100 94
xlDoughnut -4120
xlDoughnutExploded 80
xlLine 4
xlLineMarkers 65
xlLineMarkersStacked 66
xlLineMarkersStacked100 67
xlLineStacked 63
xlLineStacked100 64
xlPie 5
xlPieExploded 69
xlPieOfPie 68
xlPyramidBarClustered 109
xlPyramidBarStacked 110
xlPyramidBarStacked100 111
xlPyramidCol 112
xlPyramidColClustered 106
xlPyramidColStacked 107
xlPyramidColStacked100 108
xlRadar -4151
xlRadarFilled 82
xlRadarMarkers 81
xlStockHLC 88
xlStockOHLC 89
xlStockVHLC 90
xlStockVOHLC 91
xlSurface 83
xlSurfaceTopView 85
xlSurfaceTopViewWireframe 86
xlSurfaceWireframe 84
xlXYScatter -4169
xlXYScatterLines 74
xlXYScatterLinesNoMarkers 75
xlXYScatterSmooth 72
xlXYScatterSmoothNoMarkers 73

Show XlClipboardFormat

Constant Value
xlClipboardFormatBIFF 8
xlClipboardFormatBIFF2 18
xlClipboardFormatBIFF3 20
xlClipboardFormatBIFF4 30
xlClipboardFormatBinary 15
xlClipboardFormatBitmap 9
xlClipboardFormatCGM 13
xlClipboardFormatCSV 5
xlClipboardFormatDIF 4
xlClipboardFormatDspText 12
xlClipboardFormatEmbeddedObject 21
xlClipboardFormatEmbedSource 22
xlClipboardFormatLink 11
xlClipboardFormatLinkSource 23
xlClipboardFormatLinkSourceDesc 32
xlClipboardFormatMovie 24
xlClipboardFormatNative 14
xlClipboardFormatObjectDesc 31
xlClipboardFormatObjectLink 19
xlClipboardFormatOwnerLink 17
xlClipboardFormatPICT 2
xlClipboardFormatPrintPICT 3
xlClipboardFormatRTF 7
xlClipboardFormatScreenPICT 29
xlClipboardFormatStandardFont 28
xlClipboardFormatStandardScale 27
xlClipboardFormatSYLK 6
xlClipboardFormatTable 16
xlClipboardFormatText 0
xlClipboardFormatToolFace 25
xlClipboardFormatToolFacePICT 26
xlClipboardFormatVALU 1
xlClipboardFormatWK1 10

Show XlCmdType

Constant Value
xlCmdCube 1
xlCmdDefault 4
xlCmdList 5
xlCmdSql 2
xlCmdTable 3

Show XlColorIndex

Constant Value
xlColorIndexAutomatic -4105
xlColorIndexNone -4142

Show XlColumnDataType

Constant Value
xlDMYFormat 4
xlDYMFormat 7
xlEMDFormat 10
xlGeneralFormat 1
xlMDYFormat 3
xlMYDFormat 6
xlSkipColumn 9
xlTextFormat 2
xlYDMFormat 8
xlYMDFormat 5

Show XlCommandUnderlines

Constant Value
xlCommandUnderlinesAutomatic -4105
xlCommandUnderlinesOff -4146
xlCommandUnderlinesOn 1

Show XlCommentDisplayMode

Constant Value
xlCommentAndIndicator 1
xlCommentIndicatorOnly -1
xlNoIndicator 0

Show XlConsolidationFunction

Constant Value
xlAverage -4106
xlCount -4112
xlCountNums -4113
xlMax -4136
xlMin -4139
xlProduct -4149
xlStDev -4155
xlStDevP -4156
xlSum -4157
xlUnknown 1000
xlVar -4164
xlVarP -4165

Show XlCopyPictureFormat

Constant Value
xlBitmap 2
xlPicture -4147

Show XlCorruptLoad

Constant Value
xlExtractData 2
xlNormalLoad 0
xlRepairFile 1

Show XlCreator

Constant Value
xlCreatorCode 1480803660

Show XlCubeFieldType

Constant Value
xlHierarchy 1
xlMeasure 2
xlSet 3

Show XlCutCopyMode

Constant Value
xlCopy 1
xlCut 2

Show XlCVError

Constant Value
xlErrDiv0 2007
xlErrNA 2042
xlErrName 2029
xlErrNull 2000
xlErrNum 2036
xlErrRef 2023
xlErrValue 2015

Show XlDataLabelPosition

Constant Value
xlLabelPositionAbove 0
xlLabelPositionBelow 1
xlLabelPositionBestFit 5
xlLabelPositionCenter -4108
xlLabelPositionCustom 7
xlLabelPositionInsideBase 4
xlLabelPositionInsideEnd 3
xlLabelPositionLeft -4131
xlLabelPositionMixed 6
xlLabelPositionOutsideEnd 2
xlLabelPositionRight -4152

Show XlDataLabelSeparator

Constant Value
xlDataLabelSeparatorDefault 1

Show XlDataLabelsType

Constant Value
xlDataLabelsShowBubbleSizes 6
xlDataLabelsShowLabel 4
xlDataLabelsShowLabelAndPercent 5
xlDataLabelsShowNone -4142
xlDataLabelsShowPercent 3
xlDataLabelsShowValue 2

Show XlDataSeriesDate

Constant Value
xlDay 1
xlMonth 3
xlWeekday 2
xlYear 4

Show XlDataSeriesType

Constant Value
xlAutoFill 4
xlChronological 3
xlDataSeriesLinear -4132
xlGrowth 2

Show XlDeleteShiftDirection

Constant Value
xlShiftToLeft -4159
xlShiftUp -4162

Show XlDirection

Constant Value
xlDown -4121
xlToLeft -4159
xlToRight -4161
xlUp -4162

Show XlDisplayBlanksAs

Constant Value
xlInterpolated 3
xlNotPlotted 1
xlZero 2

Show XlDisplayDrawingObjects

Constant Value
xlDisplayShapes -4104
xlHide 3
xlPlaceholders 2

Show XlDisplayUnit

Constant Value
xlHundredMillions -8
xlHundreds -2
xlHundredThousands -5
xlMillionMillions -10
xlMillions -6
xlTenMillions -7
xlTenThousands -4
xlThousandMillions -9
xlThousands -3

Show XlDVAlertStyle

Constant Value
xlValidAlertInformation 3
xlValidAlertStop 1
xlValidAlertWarning 2

Show XlDVType

Constant Value
xlValidateCustom 7
xlValidateDate 4
xlValidateDecimal 2
xlValidateInputOnly 0
xlValidateList 3
xlValidateTextLength 6
xlValidateTime 5
xlValidateWholeNumber 1

Show XlEditionFormat

Constant Value
xlBIFF 2
xlPICT 1
xlRTF 4
xlVALU 8

Show XlEditionOptionsOption

Constant Value
xlAutomaticUpdate 4
xlCancel 1
xlChangeAttributes 6
xlManualUpdate 5
xlOpenSource 3
xlSelect 3
xlSendPublisher 2
xlUpdateSubscriber 2

Show XlEditionType

Constant Value
xlPublisher 1
xlSubscriber 2

Show XlEnableCancelKey

Constant Value
xlDisabled 0
xlErrorHandler 2
xlInterrupt 1

Show XlEnableSelection

Constant Value
xlNoRestrictions 0
xlNoSelection -4142
xlUnlockedCells 1

Show XlEndStyleCap

Constant Value
xlCap 1
xlNoCap 2

Show XlErrorBarDirection

Constant Value
xlX -4168
xlY 1

Show XlErrorBarInclude

Constant Value
xlErrorBarIncludeBoth 1
xlErrorBarIncludeMinusValues 3
xlErrorBarIncludeNone -4142
xlErrorBarIncludePlusValues 2

Show XlErrorBarType

Constant Value
xlErrorBarTypeCustom -4114
xlErrorBarTypeFixedValue 1
xlErrorBarTypePercent 2
xlErrorBarTypeStDev -4155
xlErrorBarTypeStError 4

Show XlErrorChecks

Constant Value
xlEmptyCellReferences 7
xlEvaluateToError 1
xlInconsistentFormula 4
xlListDataValidation 8
xlNumberAsText 3
xlOmittedCells 5
xlTextDate 2
xlUnlockedFormulaCells 6

Show XlFileAccess

Constant Value
xlReadOnly 3
xlReadWrite 2

Show XlFileFormat

Constant Value
xlAddIn 18
xlCSV 6
xlCSVMac 22
xlCSVMSDOS 24
xlCSVWindows 23
xlCurrentPlatformText -4158
xlDBF2 7
xlDBF3 8
xlDBF4 11
xlDIF 9
xlExcel2 16
xlExcel2FarEast 27
xlExcel3 29
xlExcel4 33
xlExcel4Workbook 35
xlExcel5 39
xlExcel7 39
xlExcel9795 43
xlHtml 44
xlIntlAddIn 26
xlIntlMacro 25
xlSYLK 2
xlTemplate 17
xlTextMac 19
xlTextMSDOS 21
xlTextPrinter 36
xlTextWindows 20
xlUnicodeText 42
xlWebArchive 45
xlWJ2WD1 14
xlWJ3 40
xlWJ3FJ3 41
xlWK1 5
xlWK1ALL 31
xlWK1FMT 30
xlWK3 15
xlWK3FM3 32
xlWK4 38
xlWKS 4
xlWorkbookNormal -4143
xlWorks2FarEast 28
xlWQ1 34
xlXMLData 47
xlXMLSpreadsheet 46

Show XlFillWith

Constant Value
xlFillWithAll -4104
xlFillWithContents 2
xlFillWithFormats -4122

Show XlFilterAction

Constant Value
xlFilterCopy 2
xlFilterInPlace 1

Show XlFindLookIn

Constant Value
xlComments -4144
xlFormulas -4123
xlValues -4163

Show XlFormatConditionOperator

Constant Value
xlBetween 1
xlEqual 3
xlGreater 5
xlGreaterEqual 7
xlLess 6
xlLessEqual 8
xlNotBetween 2
xlNotEqual 4

Show XlFormatConditionType

Constant Value
xlCellValue 1
xlExpression 2

Show XlFormControl

Constant Value
xlButtonControl 0
xlCheckBox 1
xlDropDown 2
xlEditBox 3
xlGroupBox 4
xlLabel 5
xlListBox 6
xlOptionButton 7
xlScrollBar 8
xlSpinner 9

Show XlFormulaLabel

Constant Value
xlColumnLabels 2
xlMixedLabels 3
xlNoLabels -4142
xlRowLabels 1

Show XlHAlign

Constant Value
xlHAlignCenter -4108
xlHAlignCenterAcrossSelection 7
xlHAlignDistributed -4117
xlHAlignFill 5
xlHAlignGeneral 1
xlHAlignJustify -4130
xlHAlignLeft -4131
xlHAlignRight -4152

Show XlHebrewModes

Constant Value
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1

Show XlHighlightChangesTime

Constant Value
xlAllChanges 2
xlNotYetReviewed 3
xlSinceMyLastSave 1

Show XlHtmlType

Constant Value
xlHtmlCalc 1
xlHtmlChart 3
xlHtmlList 2
xlHtmlStatic 0

Show XlIMEMode

Constant Value
xlIMEModeAlpha 8
xlIMEModeAlphaFull 7
xlIMEModeDisable 3
xlIMEModeHangul 10
xlIMEModeHangulFull 9
xlIMEModeHiragana 4
xlIMEModeKatakana 5
xlIMEModeKatakanaHalf 6
xlIMEModeNoControl 0
xlIMEModeOff 2
xlIMEModeOn 1

Show XlImportDataAs

Constant Value
xlPivotTableReport 1
xlQueryTable 0

Show XlInsertFormatOrigin

Constant Value
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1

Show XlInsertShiftDirection

Constant Value
xlShiftDown -4121
xlShiftToRight -4161

Show XlLayoutFormType

Constant Value
xlOutline 1
xlTabular 0

Show XlLegendPosition

Constant Value
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160

Show XlLineStyle

Constant Value
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13

Show XlLink

Constant Value
xlExcelLinks 1
xlOLELinks 2
xlPublishers 5
xlSubscribers 6

Show XlLinkInfo

Constant Value
xlEditionDate 2
xlLinkInfoStatus 3
xlUpdateState 1

Show XlLinkInfoType

Constant Value
xlLinkInfoOLELinks 2
xlLinkInfoPublishers 5
xlLinkInfoSubscribers 6

Show XlLinkStatus

Constant Value
xlLinkStatusCopiedValues 10
xlLinkStatusIndeterminate 5
xlLinkStatusInvalidName 7
xlLinkStatusMissingFile 1
xlLinkStatusMissingSheet 2
xlLinkStatusNotStarted 6
xlLinkStatusOK 0
xlLinkStatusOld 3
xlLinkStatusSourceNotCalculated 4
xlLinkStatusSourceNotOpen 8
xlLinkStatusSourceOpen 9

Show XlLinkType

Constant Value
xlLinkTypeExcelLinks 1
xlLinkTypeOLELinks 2

Show XlListConflict

Constant Value
xlListConflictDialog 0
xlListConflictDiscardAllConflicts 2
xlListConflictError 3
xlListConflictRetryAllConflicts 1

Show XlListDataType

Constant Value
xlListDataTypeCheckbox 9
xlListDataTypeChoice 6
xlListDataTypeChoiceMulti 7
xlListDataTypeCounter 11
xlListDataTypeCurrency 4
xlListDataTypeDateTime 5
xlListDataTypeHyperLink 10
xlListDataTypeListLookup 8
xlListDataTypeMultiLineRichText 12
xlListDataTypeMultiLineText 2
xlListDataTypeNone 0
xlListDataTypeNumber 3
xlListDataTypeText 1

Show XlListObjectSourceType

Constant Value
xlSrcExternal 0
xlSrcRange 1
xlSrcXml 2

Show XlLocationInTable

Constant Value
xlColumnHeader -4110
xlColumnItem 5
xlDataHeader 3
xlDataItem 7
xlPageHeader 2
xlPageItem 6
xlRowHeader -4153
xlRowItem 4
xlTableBody 8

Show XlLookAt

Constant Value
xlPart 2
xlWhole 1

Show XlMailSystem

Constant Value
xlMAPI 1
xlNoMailSystem 0
xlPowerTalk 2

Show XlMarkerStyle

Constant Value
xlMarkerStyleAutomatic -4105
xlMarkerStyleCircle 8
xlMarkerStyleDash -4115
xlMarkerStyleDiamond 2
xlMarkerStyleDot -4118
xlMarkerStyleNone -4142
xlMarkerStylePicture -4147
xlMarkerStylePlus 9
xlMarkerStyleSquare 1
xlMarkerStyleStar 5
xlMarkerStyleTriangle 3
xlMarkerStyleX -4168

Show XlMouseButton

Constant Value
xlNoButton 0
xlPrimaryButton 1
xlSecondaryButton 2

Show XlMousePointer

Constant Value
xlDefault -4143
xlIBeam 3
xlNorthwestArrow 1
xlWait 2

Show XlMSApplication

Constant Value
xlMicrosoftAccess 4
xlMicrosoftFoxPro 5
xlMicrosoftMail 3
xlMicrosoftPowerPoint 2
xlMicrosoftProject 6
xlMicrosoftSchedulePlus 7
xlMicrosoftWord 1

Show XlObjectSize

Constant Value
xlFitToPage 2
xlFullPage 3
xlScreenSize 1

Show XlOLEType

Constant Value
xlOLEControl 2
xlOLEEmbed 1
xlOLELink 0

Show XlOLEVerb

Constant Value
xlVerbOpen 2
xlVerbPrimary 1

Show XlOrder

Constant Value
xlDownThenOver 1
xlOverThenDown 2

Show XlOrientation

Constant Value
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166

Show XlPageBreak

Constant Value
xlPageBreakAutomatic -4105
xlPageBreakManual -4135
xlPageBreakNone -4142

Show XlPageBreakExtent

Constant Value
xlPageBreakFull 1
xlPageBreakPartial 2

Show XlPageOrientation

Constant Value
xlLandscape 2
xlPortrait 1

Show XlPaperSize

Constant Value
xlPaper10x14 16
xlPaper11x17 17
xlPaperA3 8
xlPaperA4 9
xlPaperA4Small 10
xlPaperA5 11
xlPaperB4 12
xlPaperB5 13
xlPaperCsheet 24
xlPaperDsheet 25
xlPaperEnvelope10 20
xlPaperEnvelope11 21
xlPaperEnvelope12 22
xlPaperEnvelope14 23
xlPaperEnvelope9 19
xlPaperEnvelopeB4 33
xlPaperEnvelopeB5 34
xlPaperEnvelopeB6 35
xlPaperEnvelopeC3 29
xlPaperEnvelopeC4 30
xlPaperEnvelopeC5 28
xlPaperEnvelopeC6 31
xlPaperEnvelopeC65 32
xlPaperEnvelopeDL 27
xlPaperEnvelopeItaly 36
xlPaperEnvelopeMonarch 37
xlPaperEnvelopePersonal 38
xlPaperEsheet 26
xlPaperExecutive 7
xlPaperFanfoldLegalGerman 41
xlPaperFanfoldStdGerman 40
xlPaperFanfoldUS 39
xlPaperFolio 14
xlPaperLedger 4
xlPaperLegal 5
xlPaperLetter 1
xlPaperLetterSmall 2
xlPaperNote 18
xlPaperQuarto 15
xlPaperStatement 6
xlPaperTabloid 3
xlPaperUser 256

Show XlParameterDataType

Constant Value
xlParamTypeBigInt -5
xlParamTypeBinary -2
xlParamTypeBit -7
xlParamTypeChar 1
xlParamTypeDate 9
xlParamTypeDecimal 3
xlParamTypeDouble 8
xlParamTypeFloat 6
xlParamTypeInteger 4
xlParamTypeLongVarBinary -4
xlParamTypeLongVarChar -1
xlParamTypeNumeric 2
xlParamTypeReal 7
xlParamTypeSmallInt 5
xlParamTypeTime 10
xlParamTypeTimestamp 11
xlParamTypeTinyInt -6
xlParamTypeUnknown 0
xlParamTypeVarBinary -3
xlParamTypeVarChar 12
xlParamTypeWChar -8

Show XlParameterType

Constant Value
xlConstant 1
xlPrompt 0
xlRange 2

Show XlPasteSpecialOperation

Constant Value
xlPasteSpecialOperationAdd 2
xlPasteSpecialOperationDivide 5
xlPasteSpecialOperationMultiply 4
xlPasteSpecialOperationNone -4142
xlPasteSpecialOperationSubtract 3

Show XlPasteType

Constant Value
xlPasteAll -4104
xlPasteAllExceptBorders 7
xlPasteColumnWidths 8
xlPasteComments -4144
xlPasteFormats -4122
xlPasteFormulas -4123
xlPasteFormulasAndNumberFormats 11
xlPasteValidation 6
xlPasteValues -4163
xlPasteValuesAndNumberFormats 12

Show XlPattern

Constant Value
xlPatternAutomatic -4105
xlPatternChecker 9
xlPatternCrissCross 16
xlPatternDown -4121
xlPatternGray16 17
xlPatternGray25 -4124
xlPatternGray50 -4125
xlPatternGray75 -4126
xlPatternGray8 18
xlPatternGrid 15
xlPatternHorizontal -4128
xlPatternLightDown 13
xlPatternLightHorizontal 11
xlPatternLightUp 14
xlPatternLightVertical 12
xlPatternNone -4142
xlPatternSemiGray75 10
xlPatternSolid 1
xlPatternUp -4162
xlPatternVertical -4166

Show XlPhoneticAlignment

Constant Value
xlPhoneticAlignCenter 2
xlPhoneticAlignDistributed 3
xlPhoneticAlignLeft 1
xlPhoneticAlignNoControl 0

Show XlPhoneticCharacterType

Constant Value
xlHiragana 2
xlKatakana 1
xlKatakanaHalf 0
xlNoConversion 3

Show XlPictureAppearance

Constant Value
xlPrinter 2
xlScreen 1

Show XlPictureConvertorType

Constant Value
xlBMP 1
xlCGM 7
xlDRW 4
xlDXF 5
xlEPS 8
xlHGL 6
xlPCT 13
xlPCX 10
xlPIC 11
xlPLT 12
xlTIF 9
xlWMF 2
xlWPG 3

Show XlPivotCellType

Constant Value
xlPivotCellBlankCell 9
xlPivotCellCustomSubtotal 7
xlPivotCellDataField 4
xlPivotCellDataPivotField 8
xlPivotCellGrandTotal 3
xlPivotCellPageFieldItem 6
xlPivotCellPivotField 5
xlPivotCellPivotItem 1
xlPivotCellSubtotal 2
xlPivotCellValue 0

Show XlPivotFieldCalculation

Constant Value
xlDifferenceFrom 2
xlIndex 9
xlNoAdditionalCalculation -4143
xlPercentDifferenceFrom 4
xlPercentOf 3
xlPercentOfColumn 7
xlPercentOfRow 6
xlPercentOfTotal 8
xlRunningTotal 5

Show XlPivotFieldDataType

Constant Value
xlDate 2
xlNumber -4145
xlText -4158

Show XlPivotFieldOrientation

Constant Value
xlColumnField 2
xlDataField 4
xlHidden 0
xlPageField 3
xlRowField 1

Show XlPivotFormatType

Constant Value
xlPTClassic 20
xlPTNone 21
xlReport1 0
xlReport10 9
xlReport2 1
xlReport3 2
xlReport4 3
xlReport5 4
xlReport6 5
xlReport7 6
xlReport8 7
xlReport9 8
xlTable1 10
xlTable10 19
xlTable2 11
xlTable3 12
xlTable4 13
xlTable5 14
xlTable6 15
xlTable7 16
xlTable8 17
xlTable9 18

Show XlPivotTableMissingItems

Constant Value
xlMissingItemsDefault -1
xlMissingItemsMax 32500
xlMissingItemsNone 0

Show XlPivotTableSourceType

Constant Value
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4

Show XlPivotTableVersionList

Constant Value
xlPivotTableVersion10 1
xlPivotTableVersion2000 0
xlPivotTableVersionCurrent -1

Show XlPlacement

Constant Value
xlFreeFloating 3
xlMove 2
xlMoveAndSize 1

Show XlPlatform

Constant Value
xlMacintosh 1
xlMSDOS 3
xlWindows 2

Show XlPrintErrors

Constant Value
xlPrintErrorsBlank 1
xlPrintErrorsDash 2
xlPrintErrorsDisplayed 0
xlPrintErrorsNA 3

Show XlPrintLocation

Constant Value
xlPrintInPlace 16
xlPrintNoComments -4142
xlPrintSheetEnd 1

Show XlPriority

Constant Value
xlPriorityHigh -4127
xlPriorityLow -4134
xlPriorityNormal -4143

Show XlPTSelectionMode

Constant Value
xlBlanks 4
xlButton 15
xlDataAndLabel 0
xlDataOnly 2
xlFirstRow 256
xlLabelOnly 1
xlOrigin 3

Show XlQueryType

Constant Value
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4

Show XlRangeAutoFormat

Constant Value
xlRangeAutoFormat3DEffects1 13
xlRangeAutoFormat3DEffects2 14
xlRangeAutoFormatAccounting1 4
xlRangeAutoFormatAccounting2 5
xlRangeAutoFormatAccounting3 6
xlRangeAutoFormatAccounting4 17
xlRangeAutoFormatClassic1 1
xlRangeAutoFormatClassic2 2
xlRangeAutoFormatClassic3 3
xlRangeAutoFormatClassicPivotTable 31
xlRangeAutoFormatColor1 7
xlRangeAutoFormatColor2 8
xlRangeAutoFormatColor3 9
xlRangeAutoFormatList1 10
xlRangeAutoFormatList2 11
xlRangeAutoFormatList3 12
xlRangeAutoFormatLocalFormat1 15
xlRangeAutoFormatLocalFormat2 16
xlRangeAutoFormatLocalFormat3 19
xlRangeAutoFormatLocalFormat4 20
xlRangeAutoFormatNone -4142
xlRangeAutoFormatPTNone 42
xlRangeAutoFormatReport1 21
xlRangeAutoFormatReport10 30
xlRangeAutoFormatReport2 22
xlRangeAutoFormatReport3 23
xlRangeAutoFormatReport4 24
xlRangeAutoFormatReport5 25
xlRangeAutoFormatReport6 26
xlRangeAutoFormatReport7 27
xlRangeAutoFormatReport8 28
xlRangeAutoFormatReport9 29
xlRangeAutoFormatSimple -4154
xlRangeAutoFormatTable1 32
xlRangeAutoFormatTable10 41
xlRangeAutoFormatTable2 33
xlRangeAutoFormatTable3 34
xlRangeAutoFormatTable4 35
xlRangeAutoFormatTable5 36
xlRangeAutoFormatTable6 37
xlRangeAutoFormatTable7 38
xlRangeAutoFormatTable8 39
xlRangeAutoFormatTable9 40

Show XlRangeValueDataType

Constant Value
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11

Show XlReferenceStyle

Constant Value
xlA1 1
xlR1C1 -4150

Show XlReferenceType

Constant Value
xlAbsolute 1
xlAbsRowRelColumn 2
xlRelative 4
xlRelRowAbsColumn 3

Show XlRobustConnect

Constant Value
xlAlways 1
xlAsRequired 0
xlNever 2

Show XlRoutingSlipDelivery

Constant Value
xlAllAtOnce 2
xlOneAfterAnother 1

Show XlRoutingSlipStatus

Constant Value
xlNotYetRouted 0
xlRoutingComplete 2
xlRoutingInProgress 1

Show XlRowCol

Constant Value
xlColumns 2
xlRows 1

Show XlRunAutoMacro

Constant Value
xlAutoActivate 3
xlAutoClose 2
xlAutoDeactivate 4
xlAutoOpen 1

Show XlSaveAction

Constant Value
xlDoNotSaveChanges 2
xlSaveChanges 1

Show XlSaveAsAccessMode

Constant Value
xlExclusive 3
xlNoChange 1
xlShared 2

Show XlSaveConflictResolution

Constant Value
xlLocalSessionChanges 2
xlOtherSessionChanges 3
xlUserResolution 1

Show XlScaleType

Constant Value
xlScaleLinear -4132
xlScaleLogarithmic -4133

Show XlSearchDirection

Constant Value
xlNext 1
xlPrevious 2

Show XlSearchOrder

Constant Value
xlByColumns 2
xlByRows 1

Show XlSearchWithin

Constant Value
xlWithinSheet 1
xlWithinWorkbook 2

Show XlSheetType

Constant Value
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167

Show XlSheetVisibility

Constant Value
xlSheetHidden 0
xlSheetVeryHidden 2
xlSheetVisible -1

Show XlSizeRepresents

Constant Value
xlSizeIsArea 1
xlSizeIsWidth 2

Show XlSmartTagControlType

Constant Value
xlSmartTagControlActiveX 13
xlSmartTagControlButton 6
xlSmartTagControlCheckbox 9
xlSmartTagControlCombo 12
xlSmartTagControlHelp 3
xlSmartTagControlHelpURL 4
xlSmartTagControlImage 8
xlSmartTagControlLabel 7
xlSmartTagControlLink 2
xlSmartTagControlListbox 11
xlSmartTagControlRadioGroup 14
xlSmartTagControlSeparator 5
xlSmartTagControlSmartTag 1
xlSmartTagControlTextbox 10

Show XlSmartTagDisplayMode

Constant Value
xlButtonOnly 2
xlDisplayNone 1
xlIndicatorAndButton 0

Show XlSortDataOption

Constant Value
xlSortNormal 0
xlSortTextAsNumbers 1

Show XlSortMethod

Constant Value
xlPinYin 1
xlStroke 2

Show XlSortMethodOld

Constant Value
xlCodePage 2
xlSyllabary 1

Show XlSortOrder

Constant Value
xlAscending 1
xlDescending 2

Show XlSortOrientation

Constant Value
xlSortColumns 1
xlSortRows 2

Show XlSortType

Constant Value
xlSortLabels 2
xlSortValues 1

Show XlSourceType

Constant Value
xlSourceAutoFilter 3
xlSourceChart 5
xlSourcePivotTable 6
xlSourcePrintArea 2
xlSourceQuery 7
xlSourceRange 4
xlSourceSheet 1
xlSourceWorkbook 0

Show XlSpeakDirection

Constant Value
xlSpeakByColumns 1
xlSpeakByRows 0

Show XlSpecialCellsValue

Constant Value
xlErrors 16
xlLogical 4
xlNumbers 1
xlTextValues 2

Show XlSubscribeToFormat

Constant Value
xlSubscribeToPicture -4147
xlSubscribeToText -4158

Show XlSubtototalLocationType

Constant Value
xlAtBottom 2
xlAtTop 1

Show XlSummaryColumn

Constant Value
xlSummaryOnLeft -4131
xlSummaryOnRight -4152

Show XlSummaryReportType

Constant Value
xlStandardSummary 1
xlSummaryPivotTable -4148

Show XlSummaryRow

Constant Value
xlSummaryAbove 0
xlSummaryBelow 1

Show XlTabPosition

Constant Value
xlTabPositionFirst 0
xlTabPositionLast 1

Show XlTextParsingType

Constant Value
xlDelimited 1
xlFixedWidth 2

Show XlTextQualifier

Constant Value
xlTextQualifierDoubleQuote 1
xlTextQualifierNone -4142
xlTextQualifierSingleQuote 2

Show XlTextVisualLayoutType

Constant Value
xlTextVisualLTR 1
xlTextVisualRTL 2

Show XlTickLabelOrientation

Constant Value
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166

Show XlTickLabelPosition

Constant Value
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142

Show XlTickMark

Constant Value
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3

Show XlTimeUnit

Constant Value
xlDays 0
xlMonths 1
xlYears 2

Show XlToolbarProtection

Constant Value
xlNoButtonChanges 1
xlNoChanges 4
xlNoDockingChanges 3
xlNoShapeChanges 2
xlToolbarProtectionNone -4143

Show XlTotalsCalculation

Constant Value
xlTotalsCalculationAverage 2
xlTotalsCalculationCount 3
xlTotalsCalculationCountNums 4
xlTotalsCalculationMax 6
xlTotalsCalculationMin 5
xlTotalsCalculationNone 0
xlTotalsCalculationStdDev 7
xlTotalsCalculationSum 1
xlTotalsCalculationVar 8

Show XlTrendlineType

Constant Value
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4

Show XlUnderlineStyle

Constant Value
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4

Show XlUpdateLinks

Constant Value
xlUpdateLinksAlways 3
xlUpdateLinksNever 2
xlUpdateLinksUserSetting 1

Show XlVAlign

Constant Value
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160

Show XlWBATemplate

Constant Value
xlWBATChart -4109
xlWBATExcel4IntlMacroSheet 4
xlWBATExcel4MacroSheet 3
xlWBATWorksheet -4167

Show XlWebFormatting

Constant Value
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2

Show XlWebSelectionType

Constant Value
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3

Show XlWindowState

Constant Value
xlMaximized -4137
xlMinimized -4140
xlNormal -4143

Show XlWindowType

Constant Value
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1

Show XlWindowView

Constant Value
xlNormalView 1
xlPageBreakPreview 2

Show XlXLMMacroType

Constant Value
xlCommand 2
xlFunction 1
xlNotXLM 3

Show XlXmlExportResult

Constant Value
xlXmlExportSuccess 0
xlXmlExportValidationFailed 1

Show XlXmlImportResult

Constant Value
xlXmlImportElementsTruncated 1
xlXmlImportSuccess 0
xlXmlImportValidationFailed 2

Show XlXmlLoadOption

Constant Value
xlXmlLoadImportToList 2
xlXmlLoadMapXml 3
xlXmlLoadOpenXml 1
xlXmlLoadPromptUser 0

Show XlYesNoGuess

Constant Value
xlGuess 0
xlNo 2
xlYes 1