'Copy all the text here into a new module. 'Once that is done, your Late Binding Automation will be able to use Excel's Enumerations 'Compiled by Mike Alexander 'www.datapigtechnologies.com Public Enum XlApplicationInternational 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 End Enum Public Enum XlApplyNamesOrder xlColumnThenRow = 2 xlRowThenColumn = 1 End Enum Public Enum XlArabicModes xlArabicBothStrict = 3 xlArabicNone = 0 xlArabicStrictAlefHamza = 1 xlArabicStrictFinalYaa = 2 End Enum Public Enum XlArrangeStyle xlArrangeStyleCascade = 7 xlArrangeStyleHorizontal = -4128 xlArrangeStyleTiled = 1 xlArrangeStyleVertical = -4166 End Enum Public Enum XlArrowHeadLength xlArrowHeadLengthLong = 3 xlArrowHeadLengthMedium = -4138 xlArrowHeadLengthShort = 1 End Enum Public Enum XlArrowHeadStyle xlArrowHeadStyleClosed = 3 xlArrowHeadStyleDoubleClosed = 5 xlArrowHeadStyleDoubleOpen = 4 xlArrowHeadStyleNone = -4142 xlArrowHeadStyleOpen = 2 End Enum Public Enum XlArrowHeadWidth xlArrowHeadWidthMedium = -4138 xlArrowHeadWidthNarrow = 1 xlArrowHeadWidthWide = 3 End Enum Public Enum XlAutoFillType xlFillCopy = 1 xlFillDays = 5 xlFillDefault = 0 xlFillFormats = 3 xlFillMonths = 7 xlFillSeries = 2 xlFillValues = 4 xlFillWeekdays = 6 xlFillYears = 8 xlGrowthTrend = 10 xlLinearTrend = 9 End Enum Public Enum XlAutoFilterOperator xlAnd = 1 xlBottom10Items = 4 xlBottom10Percent = 6 xlOr = 2 xlTop10Items = 3 xlTop10Percent = 5 End Enum Public Enum XlAxisCrosses xlAxisCrossesAutomatic = -4105 xlAxisCrossesCustom = -4114 xlAxisCrossesMaximum = 2 xlAxisCrossesMinimum = 4 End Enum Public Enum XlAxisGroup xlPrimary = 1 xlSecondary = 2 End Enum Public Enum XlAxisType xlCategory = 1 xlSeriesAxis = 3 xlValue = 2 End Enum Public Enum XlBackground xlBackgroundAutomatic = -4105 xlBackgroundOpaque = 3 xlBackgroundTransparent = 2 End Enum Public Enum XlBarShape xlBox = 0 xlConeToMax = 5 xlConeToPoint = 4 xlCylinder = 3 xlPyramidToMax = 2 xlPyramidToPoint = 1 End Enum Public Enum XlBordersIndex xlDiagonalDown = 5 xlDiagonalUp = 6 xlEdgeBottom = 9 xlEdgeLeft = 7 xlEdgeRight = 10 xlEdgeTop = 8 xlInsideHorizontal = 12 xlInsideVertical = 11 End Enum Public Enum XlBorderWeight xlHairline = 1 xlMedium = -4138 xlThick = 4 xlThin = 2 End Enum Public Enum XlBuiltInDialog '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 End Enum Public Enum XlCalculatedMemberType xlCalculatedMember = 0 xlCalculatedSet = 1 End Enum Public Enum XlCalculation xlCalculationAutomatic = -4105 xlCalculationManual = -4135 xlCalculationSemiautomatic = 2 End Enum Public Enum XlCalculationInterruptKey xlAnyKey = 2 xlEscKey = 1 xlNoKey = 0 End Enum Public Enum XlCalculationState xlCalculating = 1 xlDone = 0 xlPending = 2 End Enum Public Enum XlCategoryType xlAutomaticScale = -4105 xlCategoryScale = 2 xlTimeScale = 3 End Enum Public Enum XlCellInsertionMode xlInsertDeleteCells = 1 xlInsertEntireRows = 2 xlOverwriteCells = 0 End Enum Public Enum XlCellType xlCellTypeAllFormatConditions = -4172 xlCellTypeAllValidation = -4174 xlCellTypeBlanks = 4 xlCellTypeComments = -4144 xlCellTypeConstants = 2 xlCellTypeFormulas = -4123 xlCellTypeLastCell = 11 xlCellTypeSameFormatConditions = -4173 xlCellTypeSameValidation = -4175 xlCellTypeVisible = 12 End Enum Public Enum XlChartGallery xlAnyGallery = 23 xlBuiltIn = 21 xlUserDefined = 22 End Enum Public Enum XlChartItem 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 End Enum Public Enum XlChartLocation xlLocationAsNewSheet = 1 xlLocationAsObject = 2 xlLocationAutomatic = 3 End Enum Public Enum XlChartPicturePlacement xlAllFaces = 7 xlEnd = 2 xlEndSides = 3 xlFront = 4 xlFrontEnd = 6 xlFrontSides = 5 xlSides = 1 End Enum Public Enum XlChartPictureType xlStack = 2 xlStackScale = 3 xlStretch = 1 End Enum Public Enum XlChartSplitType xlSplitByCustomSplit = 4 xlSplitByPercentValue = 3 xlSplitByPosition = 1 xlSplitByValue = 2 End Enum Public Enum XlChartType 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 End Enum Public Enum XlClipboardFormat 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 End Enum Public Enum XlCmdType xlCmdCube = 1 xlCmdDefault = 4 xlCmdList = 5 xlCmdSql = 2 xlCmdTable = 3 End Enum Public Enum XlColorIndex xlColorIndexAutomatic = -4105 xlColorIndexNone = -4142 End Enum Public Enum XlColumnDataType xlDMYFormat = 4 xlDYMFormat = 7 xlEMDFormat = 10 xlGeneralFormat = 1 xlMDYFormat = 3 xlMYDFormat = 6 xlSkipColumn = 9 xlTextFormat = 2 xlYDMFormat = 8 xlYMDFormat = 5 End Enum Public Enum XlCommandUnderlines xlCommandUnderlinesAutomatic = -4105 xlCommandUnderlinesOff = -4146 xlCommandUnderlinesOn = 1 End Enum Public Enum XlCommentDisplayMode xlCommentAndIndicator = 1 xlCommentIndicatorOnly = -1 xlNoIndicator = 0 End Enum Public Enum XlConsolidationFunction xlAverage = -4106 xlCount = -4112 xlCountNums = -4113 xlMax = -4136 xlMin = -4139 xlProduct = -4149 xlStDev = -4155 xlStDevP = -4156 xlSum = -4157 xlUnknown = 1000 xlVar = -4164 xlVarP = -4165 End Enum Public Enum XlCopyPictureFormat xlBitmap = 2 xlPicture = -4147 End Enum Public Enum XlCorruptLoad xlExtractData = 2 xlNormalLoad = 0 xlRepairFile = 1 End Enum Public Enum XlCreator xlCreatorCode = 1480803660 End Enum Public Enum XlCubeFieldType xlHierarchy = 1 xlMeasure = 2 xlSet = 3 End Enum Public Enum XlCutCopyMode xlCopy = 1 xlCut = 2 End Enum Public Enum XlCVError xlErrDiv0 = 2007 xlErrNA = 2042 xlErrName = 2029 xlErrNull = 2000 xlErrNum = 2036 xlErrRef = 2023 xlErrValue = 2015 End Enum Public Enum XlDataLabelPosition xlLabelPositionAbove = 0 xlLabelPositionBelow = 1 xlLabelPositionBestFit = 5 xlLabelPositionCenter = -4108 xlLabelPositionCustom = 7 xlLabelPositionInsideBase = 4 xlLabelPositionInsideEnd = 3 xlLabelPositionLeft = -4131 xlLabelPositionMixed = 6 xlLabelPositionOutsideEnd = 2 xlLabelPositionRight = -4152 End Enum Public Enum XlDataLabelSeparator xlDataLabelSeparatorDefault = 1 End Enum Public Enum XlDataLabelsType xlDataLabelsShowBubbleSizes = 6 xlDataLabelsShowLabel = 4 xlDataLabelsShowLabelAndPercent = 5 xlDataLabelsShowNone = -4142 xlDataLabelsShowPercent = 3 xlDataLabelsShowValue = 2 End Enum Public Enum XlDataSeriesDate xlDay = 1 xlMonth = 3 xlWeekday = 2 xlYear = 4 End Enum Public Enum XlDataSeriesType xlAutoFill = 4 xlChronological = 3 xlDataSeriesLinear = -4132 xlGrowth = 2 End Enum Public Enum XlDeleteShiftDirection xlShiftToLeft = -4159 xlShiftUp = -4162 End Enum Public Enum XlDirection xlDown = -4121 xlToLeft = -4159 xlToRight = -4161 xlUp = -4162 End Enum Public Enum XlDisplayBlanksAs xlInterpolated = 3 xlNotPlotted = 1 xlZero = 2 End Enum Public Enum XlDisplayDrawingObjects xlDisplayShapes = -4104 xlHide = 3 xlPlaceholders = 2 End Enum Public Enum XlDisplayUnit xlHundredMillions = -8 xlHundreds = -2 xlHundredThousands = -5 xlMillionMillions = -10 xlMillions = -6 xlTenMillions = -7 xlTenThousands = -4 xlThousandMillions = -9 xlThousands = -3 End Enum Public Enum XlDVAlertStyle xlValidAlertInformation = 3 xlValidAlertStop = 1 xlValidAlertWarning = 2 End Enum Public Enum XlDVType xlValidateCustom = 7 xlValidateDate = 4 xlValidateDecimal = 2 xlValidateInputOnly = 0 xlValidateList = 3 xlValidateTextLength = 6 xlValidateTime = 5 xlValidateWholeNumber = 1 End Enum Public Enum XlEditionFormat xlBIFF = 2 xlPICT = 1 xlRTF = 4 xlVALU = 8 End Enum Public Enum XlEditionOptionsOption xlAutomaticUpdate = 4 xlCancel = 1 xlChangeAttributes = 6 xlManualUpdate = 5 xlOpenSource = 3 xlSelect = 3 xlSendPublisher = 2 xlUpdateSubscriber = 2 End Enum Public Enum XlEditionType xlPublisher = 1 xlSubscriber = 2 End Enum Public Enum XlEnableCancelKey xlDisabled = 0 xlErrorHandler = 2 xlInterrupt = 1 End Enum Public Enum XlEnableSelection xlNoRestrictions = 0 xlNoSelection = -4142 xlUnlockedCells = 1 End Enum Public Enum XlEndStyleCap xlCap = 1 xlNoCap = 2 End Enum Public Enum XlErrorBarDirection xlX = -4168 xlY = 1 End Enum Public Enum XlErrorBarInclude xlErrorBarIncludeBoth = 1 xlErrorBarIncludeMinusValues = 3 xlErrorBarIncludeNone = -4142 xlErrorBarIncludePlusValues = 2 End Enum Public Enum XlErrorBarType xlErrorBarTypeCustom = -4114 xlErrorBarTypeFixedValue = 1 xlErrorBarTypePercent = 2 xlErrorBarTypeStDev = -4155 xlErrorBarTypeStError = 4 End Enum Public Enum XlErrorChecks xlEmptyCellReferences = 7 xlEvaluateToError = 1 xlInconsistentFormula = 4 xlListDataValidation = 8 xlNumberAsText = 3 xlOmittedCells = 5 xlTextDate = 2 xlUnlockedFormulaCells = 6 End Enum Public Enum XlFileAccess xlReadOnly = 3 xlReadWrite = 2 End Enum Public Enum XlFileFormat 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 End Enum Public Enum XlFillWith xlFillWithAll = -4104 xlFillWithContents = 2 xlFillWithFormats = -4122 End Enum Public Enum XlFilterAction xlFilterCopy = 2 xlFilterInPlace = 1 End Enum Public Enum XlFindLookIn xlComments = -4144 xlFormulas = -4123 xlValues = -4163 End Enum Public Enum XlFormatConditionOperator xlBetween = 1 xlEqual = 3 xlGreater = 5 xlGreaterEqual = 7 xlLess = 6 xlLessEqual = 8 xlNotBetween = 2 xlNotEqual = 4 End Enum Public Enum XlFormatConditionType xlCellValue = 1 xlExpression = 2 End Enum Public Enum XlFormControl xlButtonControl = 0 xlCheckBox = 1 xlDropDown = 2 xlEditBox = 3 xlGroupBox = 4 xlLabel = 5 xlListBox = 6 xlOptionButton = 7 xlScrollBar = 8 xlSpinner = 9 End Enum Public Enum XlFormulaLabel xlColumnLabels = 2 xlMixedLabels = 3 xlNoLabels = -4142 xlRowLabels = 1 End Enum Public Enum XlHAlign xlHAlignCenter = -4108 xlHAlignCenterAcrossSelection = 7 xlHAlignDistributed = -4117 xlHAlignFill = 5 xlHAlignGeneral = 1 xlHAlignJustify = -4130 xlHAlignLeft = -4131 xlHAlignRight = -4152 End Enum Public Enum XlHebrewModes xlHebrewFullScript = 0 xlHebrewMixedAuthorizedScript = 3 xlHebrewMixedScript = 2 xlHebrewPartialScript = 1 End Enum Public Enum XlHighlightChangesTime xlAllChanges = 2 xlNotYetReviewed = 3 xlSinceMyLastSave = 1 End Enum Public Enum XlHtmlType xlHtmlCalc = 1 xlHtmlChart = 3 xlHtmlList = 2 xlHtmlStatic = 0 End Enum Public Enum XlIMEMode xlIMEModeAlpha = 8 xlIMEModeAlphaFull = 7 xlIMEModeDisable = 3 xlIMEModeHangul = 10 xlIMEModeHangulFull = 9 xlIMEModeHiragana = 4 xlIMEModeKatakana = 5 xlIMEModeKatakanaHalf = 6 xlIMEModeNoControl = 0 xlIMEModeOff = 2 xlIMEModeOn = 1 End Enum Public Enum XlImportDataAs xlPivotTableReport = 1 xlQueryTable = 0 End Enum Public Enum XlInsertFormatOrigin xlFormatFromLeftOrAbove = 0 xlFormatFromRightOrBelow = 1 End Enum Public Enum XlInsertShiftDirection xlShiftDown = -4121 xlShiftToRight = -4161 End Enum Public Enum XlLayoutFormType xlOutline = 1 xlTabular = 0 End Enum Public Enum XlLegendPosition xlLegendPositionBottom = -4107 xlLegendPositionCorner = 2 xlLegendPositionLeft = -4131 xlLegendPositionRight = -4152 xlLegendPositionTop = -4160 End Enum Public Enum XlLineStyle xlContinuous = 1 xlDash = -4115 xlDashDot = 4 xlDashDotDot = 5 xlDot = -4118 xlDouble = -4119 xlLineStyleNone = -4142 xlSlantDashDot = 13 End Enum Public Enum XlLink xlExcelLinks = 1 xlOLELinks = 2 xlPublishers = 5 xlSubscribers = 6 End Enum Public Enum XlLinkInfo xlEditionDate = 2 xlLinkInfoStatus = 3 xlUpdateState = 1 End Enum Public Enum XlLinkInfoType xlLinkInfoOLELinks = 2 xlLinkInfoPublishers = 5 xlLinkInfoSubscribers = 6 End Enum Public Enum XlLinkStatus xlLinkStatusCopiedValues = 10 xlLinkStatusIndeterminate = 5 xlLinkStatusInvalidName = 7 xlLinkStatusMissingFile = 1 xlLinkStatusMissingSheet = 2 xlLinkStatusNotStarted = 6 xlLinkStatusOK = 0 xlLinkStatusOld = 3 xlLinkStatusSourceNotCalculated = 4 xlLinkStatusSourceNotOpen = 8 xlLinkStatusSourceOpen = 9 End Enum Public Enum XlLinkType xlLinkTypeExcelLinks = 1 xlLinkTypeOLELinks = 2 End Enum Public Enum XlListConflict xlListConflictDialog = 0 xlListConflictDiscardAllConflicts = 2 xlListConflictError = 3 xlListConflictRetryAllConflicts = 1 End Enum Public Enum XlListDataType 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 End Enum Public Enum XlListObjectSourceType xlSrcExternal = 0 xlSrcRange = 1 xlSrcXml = 2 End Enum Public Enum XlLocationInTable xlColumnHeader = -4110 xlColumnItem = 5 xlDataHeader = 3 xlDataItem = 7 xlPageHeader = 2 xlPageItem = 6 xlRowHeader = -4153 xlRowItem = 4 xlTableBody = 8 End Enum Public Enum XlLookAt xlPart = 2 xlWhole = 1 End Enum Public Enum XlMailSystem xlMAPI = 1 xlNoMailSystem = 0 xlPowerTalk = 2 End Enum Public Enum XlMarkerStyle xlMarkerStyleAutomatic = -4105 xlMarkerStyleCircle = 8 xlMarkerStyleDash = -4115 xlMarkerStyleDiamond = 2 xlMarkerStyleDot = -4118 xlMarkerStyleNone = -4142 xlMarkerStylePicture = -4147 xlMarkerStylePlus = 9 xlMarkerStyleSquare = 1 xlMarkerStyleStar = 5 xlMarkerStyleTriangle = 3 xlMarkerStyleX = -4168 End Enum Public Enum XlMouseButton xlNoButton = 0 xlPrimaryButton = 1 xlSecondaryButton = 2 End Enum Public Enum XlMousePointer xlDefault = -4143 xlIBeam = 3 xlNorthwestArrow = 1 xlWait = 2 End Enum Public Enum XlMSApplication xlMicrosoftAccess = 4 xlMicrosoftFoxPro = 5 xlMicrosoftMail = 3 xlMicrosoftPowerPoint = 2 xlMicrosoftProject = 6 xlMicrosoftSchedulePlus = 7 xlMicrosoftWord = 1 End Enum Public Enum XlObjectSize xlFitToPage = 2 xlFullPage = 3 xlScreenSize = 1 End Enum Public Enum XlOLEType xlOLEControl = 2 xlOLEEmbed = 1 xlOLELink = 0 End Enum Public Enum XlOLEVerb xlVerbOpen = 2 xlVerbPrimary = 1 End Enum Public Enum XlOrder xlDownThenOver = 1 xlOverThenDown = 2 End Enum Public Enum XlOrientation xlDownward = -4170 xlHorizontal = -4128 xlUpward = -4171 xlVertical = -4166 End Enum Public Enum XlPageBreak xlPageBreakAutomatic = -4105 xlPageBreakManual = -4135 xlPageBreakNone = -4142 End Enum Public Enum XlPageBreakExtent xlPageBreakFull = 1 xlPageBreakPartial = 2 End Enum Public Enum XlPageOrientation xlLandscape = 2 xlPortrait = 1 End Enum Public Enum XlPaperSize 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 End Enum Public Enum XlParameterDataType 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 End Enum Public Enum XlParameterType xlConstant = 1 xlPrompt = 0 xlRange = 2 End Enum Public Enum XlPasteSpecialOperation xlPasteSpecialOperationAdd = 2 xlPasteSpecialOperationDivide = 5 xlPasteSpecialOperationMultiply = 4 xlPasteSpecialOperationNone = -4142 xlPasteSpecialOperationSubtract = 3 End Enum Public Enum XlPasteType xlPasteAll = -4104 xlPasteAllExceptBorders = 7 xlPasteColumnWidths = 8 xlPasteComments = -4144 xlPasteFormats = -4122 xlPasteFormulas = -4123 xlPasteFormulasAndNumberFormats = 11 xlPasteValidation = 6 xlPasteValues = -4163 xlPasteValuesAndNumberFormats = 12 End Enum Public Enum XlPattern 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 xlSolid = 1 End Enum Public Enum XlPhoneticAlignment xlPhoneticAlignCenter = 2 xlPhoneticAlignDistributed = 3 xlPhoneticAlignLeft = 1 xlPhoneticAlignNoControl = 0 End Enum Public Enum XlPhoneticCharacterType xlHiragana = 2 xlKatakana = 1 xlKatakanaHalf = 0 xlNoConversion = 3 End Enum Public Enum XlPictureAppearance xlPrinter = 2 xlScreen = 1 End Enum Public Enum XlPictureConvertorType 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 End Enum Public Enum XlPivotCellType xlPivotCellBlankCell = 9 xlPivotCellCustomSubtotal = 7 xlPivotCellDataField = 4 xlPivotCellDataPivotField = 8 xlPivotCellGrandTotal = 3 xlPivotCellPageFieldItem = 6 xlPivotCellPivotField = 5 xlPivotCellPivotItem = 1 xlPivotCellSubtotal = 2 xlPivotCellValue = 0 End Enum Public Enum XlPivotFieldCalculation xlDifferenceFrom = 2 xlIndex = 9 xlNoAdditionalCalculation = -4143 xlPercentDifferenceFrom = 4 xlPercentOf = 3 xlPercentOfColumn = 7 xlPercentOfRow = 6 xlPercentOfTotal = 8 xlRunningTotal = 5 End Enum Public Enum XlPivotFieldDataType xlDate = 2 xlNumber = -4145 xlText = -4158 End Enum Public Enum XlPivotFieldOrientation xlColumnField = 2 xlDataField = 4 xlHidden = 0 xlPageField = 3 xlRowField = 1 End Enum Public Enum XlPivotFormatType 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 End Enum Public Enum XlPivotTableMissingItems xlMissingItemsDefault = -1 xlMissingItemsMax = 32500 xlMissingItemsNone = 0 End Enum Public Enum XlPivotTableSourceType xlConsolidation = 3 xlDatabase = 1 xlExternal = 2 xlPivotTable = -4148 xlScenario = 4 End Enum Public Enum XlPivotTableVersionList xlPivotTableVersion10 = 1 xlPivotTableVersion2000 = 0 xlPivotTableVersionCurrent = -1 End Enum Public Enum XlPlacement xlFreeFloating = 3 xlMove = 2 xlMoveAndSize = 1 End Enum Public Enum XlPlatform xlMacintosh = 1 xlMSDOS = 3 xlWindows = 2 End Enum Public Enum XlPrintErrors xlPrintErrorsBlank = 1 xlPrintErrorsDash = 2 xlPrintErrorsDisplayed = 0 xlPrintErrorsNA = 3 End Enum Public Enum XlPrintLocation xlPrintInPlace = 16 xlPrintNoComments = -4142 xlPrintSheetEnd = 1 End Enum Public Enum XlPriority xlPriorityHigh = -4127 xlPriorityLow = -4134 xlPriorityNormal = -4143 End Enum Public Enum XlPTSelectionMode xlBlanks = 4 xlButton = 15 xlDataAndLabel = 0 xlDataOnly = 2 xlFirstRow = 256 xlLabelOnly = 1 xlOrigin = 3 End Enum Public Enum XlQueryType xlADORecordset = 7 xlDAORecordset = 2 xlODBCQuery = 1 xlOLEDBQuery = 5 xlTextImport = 6 xlWebQuery = 4 End Enum Public Enum XlRangeAutoFormat 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 End Enum Public Enum XlRangeValueDataType xlRangeValueDefault = 10 xlRangeValueMSPersistXML = 12 xlRangeValueXMLSpreadsheet = 11 End Enum Public Enum XlReferenceStyle xlA1 = 1 xlR1C1 = -4150 End Enum Public Enum XlReferenceType xlAbsolute = 1 xlAbsRowRelColumn = 2 xlRelative = 4 xlRelRowAbsColumn = 3 End Enum Public Enum XlRobustConnect xlAlways = 1 xlAsRequired = 0 xlNever = 2 End Enum Public Enum XlRoutingSlipDelivery xlAllAtOnce = 2 xlOneAfterAnother = 1 End Enum Public Enum XlRoutingSlipStatus xlNotYetRouted = 0 xlRoutingComplete = 2 xlRoutingInProgress = 1 End Enum Public Enum XlRowCol xlColumns = 2 xlRows = 1 End Enum Public Enum XlRunAutoMacro xlAutoActivate = 3 xlAutoClose = 2 xlAutoDeactivate = 4 xlAutoOpen = 1 End Enum Public Enum XlSaveAction xlDoNotSaveChanges = 2 xlSaveChanges = 1 End Enum Public Enum XlSaveAsAccessMode xlExclusive = 3 xlNoChange = 1 xlShared = 2 End Enum Public Enum XlSaveConflictResolution xlLocalSessionChanges = 2 xlOtherSessionChanges = 3 xlUserResolution = 1 End Enum Public Enum XlScaleType xlScaleLinear = -4132 xlScaleLogarithmic = -4133 End Enum Public Enum XlSearchDirection xlNext = 1 xlPrevious = 2 End Enum Public Enum XlSearchOrder xlByColumns = 2 xlByRows = 1 End Enum Public Enum XlSearchWithin xlWithinSheet = 1 xlWithinWorkbook = 2 End Enum Public Enum XlSheetType xlChart = -4109 xlDialogSheet = -4116 xlExcel4IntlMacroSheet = 4 xlExcel4MacroSheet = 3 xlWorksheet = -4167 End Enum Public Enum XlSheetVisibility xlSheetHidden = 0 xlSheetVeryHidden = 2 xlSheetVisible = -1 End Enum Public Enum XlSizeRepresents xlSizeIsArea = 1 xlSizeIsWidth = 2 End Enum Public Enum XlSmartTagControlType 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 End Enum Public Enum XlSmartTagDisplayMode xlButtonOnly = 2 xlDisplayNone = 1 xlIndicatorAndButton = 0 End Enum Public Enum XlSortDataOption xlSortNormal = 0 xlSortTextAsNumbers = 1 End Enum Public Enum XlSortMethod xlPinYin = 1 xlStroke = 2 End Enum Public Enum XlSortMethodOld xlCodePage = 2 xlSyllabary = 1 End Enum Public Enum XlSortOrder xlAscending = 1 xlDescending = 2 End Enum Public Enum XlSortOrientation xlSortColumns = 1 xlSortRows = 2 End Enum Public Enum XlSortType xlSortLabels = 2 xlSortValues = 1 End Enum Public Enum XlSourceType xlSourceAutoFilter = 3 xlSourceChart = 5 xlSourcePivotTable = 6 xlSourcePrintArea = 2 xlSourceQuery = 7 xlSourceRange = 4 xlSourceSheet = 1 xlSourceWorkbook = 0 End Enum Public Enum XlSpeakDirection xlSpeakByColumns = 1 xlSpeakByRows = 0 End Enum Public Enum XlSpecialCellsValue xlErrors = 16 xlLogical = 4 xlNumbers = 1 xlTextValues = 2 End Enum Public Enum XlSubscribeToFormat xlSubscribeToPicture = -4147 xlSubscribeToText = -4158 End Enum Public Enum XlSubtototalLocationType xlAtBottom = 2 xlAtTop = 1 End Enum Public Enum XlSummaryColumn xlSummaryOnLeft = -4131 xlSummaryOnRight = -4152 End Enum Public Enum XlSummaryReportType xlStandardSummary = 1 xlSummaryPivotTable = -4148 End Enum Public Enum XlSummaryRow xlSummaryAbove = 0 xlSummaryBelow = 1 End Enum Public Enum XlTabPosition xlTabPositionFirst = 0 xlTabPositionLast = 1 End Enum Public Enum XlTextParsingType xlDelimited = 1 xlFixedWidth = 2 End Enum Public Enum XlTextQualifier xlTextQualifierDoubleQuote = 1 xlTextQualifierNone = -4142 xlTextQualifierSingleQuote = 2 End Enum Public Enum XlTextVisualLayoutType xlTextVisualLTR = 1 xlTextVisualRTL = 2 End Enum Public Enum XlTickLabelOrientation xlTickLabelOrientationAutomatic = -4105 xlTickLabelOrientationDownward = -4170 xlTickLabelOrientationHorizontal = -4128 xlTickLabelOrientationUpward = -4171 xlTickLabelOrientationVertical = -4166 End Enum Public Enum XlTickLabelPosition xlTickLabelPositionHigh = -4127 xlTickLabelPositionLow = -4134 xlTickLabelPositionNextToAxis = 4 xlTickLabelPositionNone = -4142 End Enum Public Enum XlTickMark xlTickMarkCross = 4 xlTickMarkInside = 2 xlTickMarkNone = -4142 xlTickMarkOutside = 3 End Enum Public Enum XlTimeUnit xlDays = 0 xlMonths = 1 xlYears = 2 End Enum Public Enum XlToolbarProtection xlNoButtonChanges = 1 xlNoChanges = 4 xlNoDockingChanges = 3 xlNoShapeChanges = 2 xlToolbarProtectionNone = -4143 End Enum Public Enum XlTotalsCalculation xlTotalsCalculationAverage = 2 xlTotalsCalculationCount = 3 xlTotalsCalculationCountNums = 4 xlTotalsCalculationMax = 6 xlTotalsCalculationMin = 5 xlTotalsCalculationNone = 0 xlTotalsCalculationStdDev = 7 xlTotalsCalculationSum = 1 xlTotalsCalculationVar = 8 End Enum Public Enum XlTrendlineType xlExponential = 5 xlLinear = -4132 xlLogarithmic = -4133 xlMovingAvg = 6 xlPolynomial = 3 xlPower = 4 End Enum Public Enum XlUnderlineStyle xlUnderlineStyleDouble = -4119 xlUnderlineStyleDoubleAccounting = 5 xlUnderlineStyleNone = -4142 xlUnderlineStyleSingle = 2 xlUnderlineStyleSingleAccounting = 4 End Enum Public Enum XlUpdateLinks xlUpdateLinksAlways = 3 xlUpdateLinksNever = 2 xlUpdateLinksUserSetting = 1 End Enum Public Enum XlVAlign xlVAlignBottom = -4107 xlVAlignCenter = -4108 xlVAlignDistributed = -4117 xlVAlignJustify = -4130 xlVAlignTop = -4160 End Enum Public Enum XlWBATemplate xlWBATChart = -4109 xlWBATExcel4IntlMacroSheet = 4 xlWBATExcel4MacroSheet = 3 xlWBATWorksheet = -4167 End Enum Public Enum XlWebFormatting xlWebFormattingAll = 1 xlWebFormattingNone = 3 xlWebFormattingRTF = 2 End Enum Public Enum XlWebSelectionType xlAllTables = 2 xlEntirePage = 1 xlSpecifiedTables = 3 End Enum Public Enum XlWindowState xlMaximized = -4137 xlMinimized = -4140 xlNormal = -4143 End Enum Public Enum XlWindowType xlChartAsWindow = 5 xlChartInPlace = 4 xlClipboard = 3 xlInfo = -4129 xlWorkbook = 1 End Enum Public Enum XlWindowView xlNormalView = 1 xlPageBreakPreview = 2 End Enum Public Enum XlXLMMacroType xlCommand = 2 xlFunction = 1 xlNotXLM = 3 End Enum Public Enum XlXmlExportResult xlXmlExportSuccess = 0 xlXmlExportValidationFailed = 1 End Enum Public Enum XlXmlImportResult xlXmlImportElementsTruncated = 1 xlXmlImportSuccess = 0 xlXmlImportValidationFailed = 2 End Enum Public Enum XlXmlLoadOption xlXmlLoadImportToList = 2 xlXmlLoadMapXml = 3 xlXmlLoadOpenXml = 1 xlXmlLoadPromptUser = 0 End Enum Public Enum XlYesNoGuess xlGuess = 0 xlNo = 2 xlYes = 1 End Enum Public Enum xlColorIndex 'Courtesy of Bob Phillips xlCIBlack = 1 xlCIWhite = 2 xlCIRed = 3 xlCIBrightGreen = 4 xlCIBlue = 5 xlCIYellow = 6 xlCIPink = 7 xlCITurquoise = 8 xlCIDarkRed = 9 xlCIGreen = 10 xlCIDarkBlue = 11 xlCIDarkYellow = 12 xlCIViolet = 13 xlCITeal = 14 xlCIGray25 = 15 xlCIGray50 = 16 xlChartCIPeriwinkle = 17 ‘—————————– xlChartCIPlum = 18 ‘ chart colours xlChartCIIvory = 19 ‘ xlChartCILightTurquoise = 20 ‘ xlChartCIDarkPurple = 21 ‘ xlChartCICoral = 22 ‘ xlChartCIOceanBlue = 23 ‘ xlChartCIIceBlue = 24 ‘ xlChartCIDarkBlue = 25 ‘ xlChartCIPink = 26 ‘ xlChartCIYellow = 27 ‘ xlChartCITurquoise = 28 ‘ xlChartCIViolet = 29 ‘ xlChartCIDarkRed = 30 ‘ xlChartCITeal = 31 ‘ xlChartCIBlue = 32 ‘—————————– xlCISkyBlue = 33 xlCILightGreen = 35 xlCILightYellow = 36 xlCIPaleBlue = 37 xlCIRose = 38 xlCILavender = 39 xlCITan = 40 xlCILightBlue = 41 xlCIAqua = 42 xlCILime = 43 xlCIGold = 44 xlCILightOrange = 45 xlCIOrange = 46 xlCIBlueGray = 47 xlCIGray40 = 48 xlCIDarkTeal = 49 xlCISeaGreen = 50 xlCIDarkGreen = 51 xlCIBrown = 53 xlCIIndigo = 55 xlCIGray80 = 56 End Enum