** NORMAS DEL FORO **
Inicio del foro Inicio del foro > Access y VBA > Tus Funciones Favoritas & Aportaciones & Artí­culos
  Mensajes nuevos Mensajes nuevos RSS - VBA: Access - Excel. Códigos Automatización
  Preguntas frecuentes Preguntas frecuentes  Buscar en el foro   Eventos   Registro Registro  Iniciar sesion Iniciar sesion

Tema cerradoVBA: Access - Excel. Códigos Automatización

 Responder Responder
Autor
Mensaje
genoma111 Ver desplegable
Administrador
Administrador
Avatar

Unido: 28/Marzo/2011
Localización: ...
Estado: Sin conexión
Puntos: 3248
Enlace directo a este mensaje Tema: VBA: Access - Excel. Códigos Automatización
    Enviado: 27/Septiembre/2013 a las 03:05
Una excelente y muy completa lista de códigos para automatización de Access a Excel utilizando Late Binding.
http://www.datapigtechnologies.com/downloads/Excel_Enumerations.txt

'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

"To VBA or not to VBA... that's the question" DFP
Arriba
 Responder Responder
  Compartir tema   

Ir al foro Permisos de foro Ver desplegable