Excel 参数值

Excel Excel TypeLib(Excel9.olb) /// 全部的请参看 Excel9.OLB 文件 ,下面只是一些常量定义！ Excel; // Microsoft Excel 9.0 Object Library Enum Constants; xlAll = $ FFFFEFF8; xlAutomatic = $ FFFFEFF7; xlBoth = 1; xlCenter = $ FFFFEFF4; xlChecker = 9; xlCircle = 8; xlCorner = 2; xlCrissCross = 16; xlCross = 4; xlDiamond = 2; xlDistributed = $ FFFFEFEB; xlDoubleAccounting = 5; xlFixedValue = 1; xlFormats = $ FFFFEFE6; xlGray16 = 17; xlGray8 = 18; xlGrid = 15; xlHigh = $ FFFFEFE1; xlInside = 2; xlJustify = $ FFFFEFDE; xlLightDown = 13; xlLightHorizontal = 11; xlLightUp = 14; xlLightVertical = 12; xlLow = $ FFFFEFDA; xlManual = $ FFFFEFD9; xlMinusValues = 3; xlModule = $ FFFFEFD3; xlNextToAxis = 4; xlNone = $ FFFFEFD2; xlNotes = $ FFFFEFD0; xlOff = $ FFFFEFCE; xlOn = 1; xlPercent = 2; xlPlus = 9; xlPlusValues = 2; xlSemiGray75 = 10; xlShowLabel = 4; xlShowLabelAndPercent = 5; xlShowPercent = 3; xlShowValue = 2; xlSimple = $ FFFFEFC6; xlSingle = 2; xlSingleAccounting = 4; xlSolid = 1; xlSquare = 1; xlStar = 5; xlStError = 4; xlToolbarButton = 2; xlTriangle = 3; xlGray25 = $ FFFFEFE4; xlGray50 = $ FFFFEFE3; xlGray75 = $ FFFFEFE2; xlBottom = $ FFFFEFF5; xlLeft = $ FFFFEFDD; xlRight = $ FFFFEFC8; xlTop = $ FFFFEFC0; xl3DBar = $ FFFFEFFD; xl3DSurface = $ FFFFEFF9; xlBar = 2; xlColumn = 3; xlCombination = $ FFFFEFF1; xlCustom = $ FFFFEFEE; xlDefaultAutoFormat = -1; xlMaximum = 2; xlMinimum = 4; xlOpaque = 3; xlTransparent = 2; xlBidi = $ FFFFEC78; xlLatin = $ FFFFEC77; xlContext = $ FFFFEC76; xlLTR = $ FFFFEC75; xlRTL = $ FFFFEC74; xlFullScript = 1; xlPartialScript = 2; xlMixedScript = 3; xlMixedAuthorizedScript = 4; xlVisualCursor = 2; xlLogicalCursor = 1; xlSystem = 1; xlPartial = 3; xlHindiNumerals = 3; xlBidiCalendar = 3; xlGregorian = 2; xlComplete = 4; xlScale = 3; xlClosed = 3; xlColor1 = 7; xlColor2 = 8; xlColor3 = 9; xlConstants = 2; xlContents = 2; xlBelow = 1; xlCascade = 7; xlCenterAcrossSelection = 7; xlChart4 = 2; xlChartSeries = 17; xlChartShort = 6; xlChartTitles = 18; xlClassic1 = 1; xlClassic2 = 2; xlClassic3 = 3; xl3DEffects1 = 13; xl3DEffects2 = 14; xlAbove = 0; xlAccounting1 = 4; xlAccounting2 = 5; xlAccounting3 = 6; xlAccounting4 = 17; xlAdd = 2; xlDebugCodePane = 13; xlDesktop = 9; xlDirect = 1; xlDivide = 5; xlDoubleClosed = 5; xlDoubleOpen = 4; xlDoubleQuote = 1; xlEntireChart = 20; xlExcelMenus = 1; xlExtended = 3; xlFill = 5; xlFirst = 0; xlFloating = 5; xlFormula = 5; xlGeneral = 1; xlGridline = 22; xlIcons = 1; xlImmediatePane = 12; xlInteger = 2; xlLast = 1; xlLastCell = 11; xlList1 = 10; xlList2 = 11; xlList3 = 12; xlLocalFormat1 = 15; xlLocalFormat2 = 16; xlLong = 3; xlLotusHelp = 2; xlMacrosheetCell = 7; xlMixed = 2; xlMultiply = 4; xlNarrow = 1; xlNoDocuments = 3; xlOpen = 2; xlOutside = 3; xlReference = 4; xlSemiautomatic = 2; xlShort = 1; xlSingleQuote = 2; xlStrict = 2; xlSubtract = 3; xlTextBox = 16; xlTiled = 1; xlTitleBar = 8; xlToolbar = 1; xlVisible = 12; xlWatchPane = 11; xlWide = 3; xlWorkbookTab = 6; xlWorksheet4 = 1; xlWorksheetCell = 3; xlWorksheetShort = 5; xlAllExceptBorders = 6; xlLeftToRight = 2; xlTopToBottom = 1; xlVeryHidden = 2; xlDrawingObject = 14; Enum XlCreator; xlCreatorCode = $ 5843454C; Enum XlChartGallery; xlBuiltIn = 21; xlUserDefined = 22; xlAnyGallery = 23; Enum XlColorIndex; xlColorIndexAutomatic = $ FFFFEFF7; xlColorIndexNone = $ FFFFEFD2; Enum XlEndStyleCap; xlCap = 1; xlNoCap = 2; Enum XlRowCol; xlColumns = 2; xlRows = 1; Enum XlScaleType; xlScaleLinear = $ FFFFEFDC; xlScaleLogarithmic = $ FFFFEFDB; Enum XlDataSeriesType; xlAutoFill = 4; xlChronological = 3; xlGrowth = 2; xlDataSeriesLinear = $ FFFFEFDC; Enum XlAxisCrosses; xlAxisCrossesAutomatic = $ FFFFEFF7; xlAxisCrossesCustom = $ FFFFEFEE; xlAxisCrossesMaximum = 2; xlAxisCrossesMinimum = 4; Enum XlAxisGroup; xlPrimary = 1; xlSecondary = 2; Enum XlBackground; xlBackgroundAutomatic = $ FFFFEFF7; xlBackgroundOpaque = 3; xlBackgroundTransparent = 2; Enum XlWindowState; xlMaximized = $ FFFFEFD7; xlMinimized = $ FFFFEFD4; xlNormal = $ FFFFEFD1; Enum XlAxisType; xlCategory = 1; xlSeriesAxis = 3; xlValue = 2; Enum XlArrowHeadLength; xlArrowHeadLengthLong = 3; xlArrowHeadLengthMedium = $ FFFFEFD6; xlArrowHeadLengthShort = 1; Enum XlVAlign; xlVAlignBottom = $ FFFFEFF5; xlVAlignCenter = $ FFFFEFF4; xlVAlignDistributed = $ FFFFEFEB; xlVAlignJustify = $ FFFFEFDE; xlVAlignTop = $ FFFFEFC0; Enum XlTickMark; xlTickMarkCross = 4; xlTickMarkInside = 2; xlTickMarkNone = $ FFFFEFD2; xlTickMarkOutside = 3; Enum XlErrorBarDirection; xlX = $ FFFFEFB8; xlY = 1; Enum XlErrorBarInclude; xlErrorBarIncludeBoth = 1; xlErrorBarIncludeMinusValues = 3; xlErrorBarIncludeNone = $ FFFFEFD2; xlErrorBarIncludePlusValues = 2; Enum XlDisplayBlanksAs; xlInterpolated = 3; xlNotPlotted = 1; xlZero = 2; Enum XlArrowHeadStyle; xlArrowHeadStyleClosed = 3; xlArrowHeadStyleDoubleClosed = 5; xlArrowHeadStyleDoubleOpen = 4; xlArrowHeadStyleNone = $ FFFFEFD2; xlArrowHeadStyleOpen = 2; Enum XlArrowHeadWidth; xlArrowHeadWidthMedium = $ FFFFEFD6; xlArrowHeadWidthNarrow = 1; xlArrowHeadWidthWide = 3; Enum XlHAlign; xlHAlignCenter = $ FFFFEFF4; xlHAlignCenterAcrossSelection = 7; xlHAlignDistributed = $ FFFFEFEB; xlHAlignFill = 5; xlHAlignGeneral = 1; xlHAlignJustify = $ FFFFEFDE; xlHAlignLeft = $ FFFFEFDD; xlHAlignRight = $ FFFFEFC8; Enum XlTickLabelPosition; xlTickLabelPositionHigh = $ FFFFEFE1; xlTickLabelPositionLow = $ FFFFEFDA; xlTickLabelPositionNextToAxis = 4; xlTickLabelPositionNone = $ FFFFEFD2; Enum XlLegendPosition; xlLegendPositionBottom = $ FFFFEFF5; xlLegendPositionCorner = 2; xlLegendPositionLeft = $ FFFFEFDD; xlLegendPositionRight = $ FFFFEFC8; xlLegendPositionTop = $ FFFFEFC0; Enum XlChartPictureType; xlStackScale = 3; xlStack = 2; xlStretch = 1; Enum XlChartPicturePlacement; xlSides = 1; xlEnd = 2; xlEndSides = 3; xlFront = 4; xlFrontSides = 5; xlFrontEnd = 6; xlAllFaces = 7; Enum XlOrientation; xlDownward = $ FFFFEFB6; xlHorizontal = $ FFFFEFE0; xlUpward = $ FFFFEFB5; xlVertical = $ FFFFEFBA; Enum XlTickLabelOrientation; xlTickLabelOrientationAutomatic = $ FFFFEFF7; xlTickLabelOrientationDownward = $ FFFFEFB6; xlTickLabelOrientationHorizontal = $ FFFFEFE0; xlTickLabelOrientationUpward = $ FFFFEFB5; xlTickLabelOrientationVertical = $ FFFFEFBA; Enum XlBorderWeight; xlHairline = 1; xlMedium = $ FFFFEFD6; xlThick = 4; xlThin = 2; Enum XlDataSeriesDate; xlDay = 1; xlMonth = 3; xlWeekday = 2; xlYear = 4; Enum XlUnderlineStyle; xlUnderlineStyleDouble = $ FFFFEFE9; xlUnderlineStyleDoubleAccounting = 5; xlUnderlineStyleNone = $ FFFFEFD2; xlUnderlineStyleSingle = 2; xlUnderlineStyleSingleAccounting = 4; Enum XlErrorBarType; xlErrorBarTypeCustom = $ FFFFEFEE; xlErrorBarTypeFixedValue = 1; xlErrorBarTypePercent = 2; xlErrorBarTypeStDev = $ FFFFEFC5; xlErrorBarTypeStError = 4; Enum XlTrendlineType; xlExponential = 5; xlLinear = $ FFFFEFDC; xlLogarithmic = $ FFFFEFDB; xlMovingAvg = 6; xlPolynomial = 3; xlPower = 4; Enum XlLineStyle; xlContinuous = 1; xlDash = $ FFFFEFED; xlDashDot = 4; xlDashDotDot = 5; xlDot = $ FFFFEFEA; xlDouble = $ FFFFEFE9; xlSlantDashDot = 13; xlLineStyleNone = $ FFFFEFD2; Enum XlDataLabelsType; xlDataLabelsShowNone = $ FFFFEFD2; xlDataLabelsShowValue = 2; xlDataLabelsShowPercent = 3; xlDataLabelsShowLabel = 4; xlDataLabelsShowLabelAndPercent = 5; xlDataLabelsShowBubbleSizes = 6; Enum XlMarkerStyle; xlMarkerStyleAutomatic = $ FFFFEFF7; xlMarkerStyleCircle = 8; xlMarkerStyleDash = $ FFFFEFED; xlMarkerStyleDiamond = 2; xlMarkerStyleDot = $ FFFFEFEA; xlMarkerStyleNone = $ FFFFEFD2; xlMarkerStylePicture = $ FFFFEFCD; xlMarkerStylePlus = 9; xlMarkerStyleSquare = 1; xlMarkerStyleStar = 5; xlMarkerStyleTriangle = 3; xlMarkerStyleX = $ FFFFEFB8; 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; Enum XlPattern; xlPatternAutomatic = $ FFFFEFF7; xlPatternChecker = 9; xlPatternCrissCross = 16; xlPatternDown = $ FFFFEFE7; xlPatternGray16 = 17; xlPatternGray25 = $ FFFFEFE4; xlPatternGray50 = $ FFFFEFE3; xlPatternGray75 = $ FFFFEFE2; xlPatternGray8 = 18; xlPatternGrid = 15; xlPatternHorizontal = $ FFFFEFE0; xlPatternLightDown = 13; xlPatternLightHorizontal = 11; xlPatternLightUp = 14; xlPatternLightVertical = 12; xlPatternNone = $ FFFFEFD2; xlPatternSemiGray75 = 10; xlPatternSolid = 1; xlPatternUp = $ FFFFEFBE; xlPatternVertical = $ FFFFEFBA; Enum XlChartSplitType; xlSplitByPosition = 1; xlSplitByPercentValue = 3; xlSplitByCustomSplit = 4; xlSplitByValue = 2; Enum XlDisplayUnit; xlHundreds = -2; xlThousands = -3; xlTenThousands = -4; xlHundredThousands = -5; xlMillions = -6; xlTenMillions = -7; xlHundredMillions = -8; xlThousandMillions = -9; xlMillionMillions = -10; Enum XlDataLabelPosition; xlLabelPositionCenter = $ FFFFEFF4; xlLabelPositionAbove = 0; xlLabelPositionBelow = 1; xlLabelPositionLeft = $ FFFFEFDD; xlLabelPositionRight = $ FFFFEFC8; xlLabelPositionOutsideEnd = 2; xlLabelPositionInsideEnd = 3; xlLabelPositionInsideBase = 4; xlLabelPositionBestFit = 5; xlLabelPositionMixed = 6; xlLabelPositionCustom = 7; Enum XlTimeUnit; xlDays = 0; xlMonths = 1; xlYears = 2; Enum XlCategoryType; xlCategoryScale = 2; xlTimeScale = 3; xlAutomaticScale = $ FFFFEFF7; Enum XlBarShape; xlBox = 0; xlPyramidToPoint = 1; xlPyramidToMax = 2; xlCylinder = 3; xlConeToPoint = 4; xlConeToMax = 5; Enum XlChartType; xlColumnClustered = 51; xlColumnStacked = 52; xlColumnStacked100 = 53; xl3DColumnClustered = 54; xl3DColumnStacked = 55; xl3DColumnStacked100 = 56; xlBarClustered = 57; xlBarStacked = 58; xlBarStacked100 = 59; xl3DBarClustered = 60; xl3DBarStacked = 61; xl3DBarStacked100 = 62; xlLineStacked = 63; xlLineStacked100 = 64; xlLineMarkers = 65; xlLineMarkersStacked = 66; xlLineMarkersStacked100 = 67; xlPieOfPie = 68; xlPieExploded = 69; xl3DPieExploded = 70; xlBarOfPie = 71; xlXYScatterSmooth = 72; xlXYScatterSmoothNoMarkers = 73; xlXYScatterLines = 74; xlXYScatterLinesNoMarkers = 75; xlAreaStacked = 76; xlAreaStacked100 = 77; xl3DAreaStacked = 78; xl3DAreaStacked100 = 79; xlDoughnutExploded = 80; xlRadarMarkers = 81; xlRadarFilled = 82; xlSurface = 83; xlSurfaceWireframe = 84; xlSurfaceTopView = 85; xlSurfaceTopViewWireframe = 86; xlBubble = 15; xlBubble3DEffect = 87; xlStockHLC = 88; xlStockOHLC = 89; xlStockVHLC = 90; xlStockVOHLC = 91; xlCylinderColClustered = 92; xlCylinderColStacked = 93; xlCylinderColStacked100 = 94; xlCylinderBarClustered = 95; xlCylinderBarStacked = 96; xlCylinderBarStacked100 = 97; xlCylinderCol = 98; xlConeColClustered = 99; xlConeColStacked = 100; xlConeColStacked100 = 101; xlConeBarClustered = 102; xlConeBarStacked = 103; xlConeBarStacked100 = 104; xlConeCol = 105; xlPyramidColClustered = 106; xlPyramidColStacked = 107; xlPyramidColStacked100 = 108; xlPyramidBarClustered = 109; xlPyramidBarStacked = 110; xlPyramidBarStacked100 = 111; xlPyramidCol = 112; xl3DColumn = $ FFFFEFFC; xlLine = 4; xl3DLine = $ FFFFEFFB; xl3DPie = $ FFFFEFFA; xlPie = 5; xlXYScatter = $ FFFFEFB7; xl3DArea = $ FFFFEFFE; xlArea = 1; xlDoughnut = $ FFFFEFE8; xlRadar = $ FFFFEFC9; Enum XlChartItem; xlDataLabel = 0; xlChartArea = 2; xlSeries = 3; xlChartTitle = 4; xlWalls = 5; xlCorners = 6; xlDataTable = 7; xlTrendline = 8; xlErrorBars = 9; xlXErrorBars = 10; xlYErrorBars = 11; xlLegendEntry = 12; xlLegendKey = 13; xlShape = 14; xlMajorGridlines = 15; xlMinorGridlines = 16; xlAxisTitle = 17; xlUpBars = 18; xlPlotArea = 19; xlDownBars = 20; xlAxis = 21; xlSeriesLines = 22; xlFloor = 23; xlLegend = 24; xlHiLoLines = 25; xlDropLines = 26; xlRadarAxisLabels = 27; xlNothing = 28; xlLeaderLines = 29; xlDisplayUnitLabel = 30; xlPivotChartFieldButton = 31; xlPivotChartDropZone = 32; Enum XlSizeRepresents; xlSizeIsWidth = 2; xlSizeIsArea = 1; Enum XlInsertShiftDirection; xlShiftDown = $ FFFFEFE7; xlShiftToRight = $ FFFFEFBF; Enum XlDeleteShiftDirection; xlShiftToLeft = $ FFFFEFC1; xlShiftUp = $ FFFFEFBE; Enum XlDirection; xlDown = $ FFFFEFE7; xlToLeft = $ FFFFEFC1; xlToRight = $ FFFFEFBF; xlUp = $ FFFFEFBE; Enum XlConsolidationFunction; xlAverage = $ FFFFEFF6; xlCount = $ FFFFEFF0; xlCountNums = $ FFFFEFEF; xlMax = $ FFFFEFD8; xlMin = $ FFFFEFD5; xlProduct = $ FFFFEFCB; xlStDev = $ FFFFEFC5; xlStDevP = $ FFFFEFC4; xlSum = $ FFFFEFC3; xlVar = $ FFFFEFBC; xlVarP = $ FFFFEFBB; xlUnknown = $ 3E8; Enum XlSheetType; xlChart = $ FFFFEFF3; xlDialogSheet = $ FFFFEFEC; xlExcel4IntlMacroSheet = 4; xlExcel4MacroSheet = 3; xlWorksheet = $ FFFFEFB9; Enum XlLocationInTable; xlColumnHeader = $ FFFFEFF2; xlColumnItem = 5; xlDataHeader = 3; xlDataItem = 7; xlPageHeader = 2; xlPageItem = 6; xlRowHeader = $ FFFFEFC7; xlRowItem = 4; xlTableBody = 8; Enum XlFindLookIn; xlFormulas = $ FFFFEFE5; xlComments = $ FFFFEFD0; xlValues = $ FFFFEFBD; Enum XlWindowType; xlChartAsWindow = 5; xlChartInPlace = 4; xlClipboard = 3; xlInfo = $ FFFFEFDF; xlWorkbook = 1; Enum XlPivotFieldDataType; xlDate = 2; xlNumber = $ FFFFEFCF; xlText = $ FFFFEFC2; Enum XlCopyPictureFormat; xlBitmap = 2; xlPicture = $ FFFFEFCD; Enum XlPivotTableSourceType; xlConsolidation = 3; xlDatabase = 1; xlExternal = 2; xlPivotTable = $ FFFFEFCC; Enum XlReferenceStyle; xlA1 = 1; xlR1C1 = $ FFFFEFCA; Enum XlMSApplication; xlMicrosoftAccess = 4; xlMicrosoftFoxPro = 5; xlMicrosoftMail = 3; xlMicrosoftPowerPoint = 2; xlMicrosoftProject = 6; xlMicrosoftSchedulePlus = 7; xlMicrosoftWord = 1; Enum XlMouseButton; xlNoButton = 0; xlPrimaryButton = 1; xlSecondaryButton = 2; Enum XlCutCopyMode; xlCopy = 1; xlCut = 2; Enum XlFillWith; xlFillWithAll = $ FFFFEFF8; xlFillWithContents = 2; xlFillWithFormats = $ FFFFEFE6; Enum XlFilterAction; xlFilterCopy = 2; xlFilterInPlace = 1; Enum XlOrder; xlDownThenOver = 1; xlOverThenDown = 2; Enum XlLinkType; xlLinkTypeExcelLinks = 1; xlLinkTypeOLELinks = 2; Enum XlApplyNamesOrder; xlColumnThenRow = 2; xlRowThenColumn = 1; Enum XlEnableCancelKey; xlDisabled = 0; xlErrorHandler = 2; xlInterrupt = 1; Enum XlPageBreak; xlPageBreakAutomatic = $ FFFFEFF7; xlPageBreakManual = $ FFFFEFD9; xlPageBreakNone = $ FFFFEFD2; Enum XlOLEType; xlOLEControl = 2; xlOLEEmbed = 1; xlOLELink = 0; Enum XlPageOrientation; xlLandscape = 2; xlPortrait = 1; Enum XlLinkInfo; xlEditionDate = 2; xlUpdateState = 1; Enum XlCommandUnderlines; xlCommandUnderlinesAutomatic = $ FFFFEFF7; xlCommandUnderlinesOff = $ FFFFEFCE; xlCommandUnderlinesOn = 1; Enum XlOLEVerb; xlVerbOpen = 2; xlVerbPrimary = 1; Enum XlCalculation; xlCalculationAutomatic = $ FFFFEFF7; xlCalculationManual = $ FFFFEFD9; xlCalculationSemiautomatic = 2; Enum XlFileAccess; xlReadOnly = 3; xlReadWrite = 2; Enum XlEditionType; xlPublisher = 1; xlSubscriber = 2; Enum XlObjectSize; xlFitToPage = 2; xlFullPage = 3; xlScreenSize = 1; Enum XlLookAt; xlPart = 2; xlWhole = 1; Enum XlMailSystem; xlMAPI = 1; xlNoMailSystem = 0; xlPowerTalk = 2; Enum XlLinkInfoType; xlLinkInfoOLELinks = 2; xlLinkInfoPublishers = 5; xlLinkInfoSubscribers = 6; Enum XlCVError; xlErrDiv0 = $ 7D7; xlErrNA = $ 7FA; xlErrName = $ 7ED; xlErrNull = $ 7D0; xlErrNum = $ 7F4; xlErrRef = $ 7E7; xlErrValue = $ 7DF; Enum XlEditionFormat; xlBIFF = 2; xlPICT = 1; xlRTF = 4; xlVALU = 8; Enum XlLink; xlExcelLinks = 1; xlOLELinks = 2; xlPublishers = 5; xlSubscribers = 6; Enum XlCellType; xlCellTypeBlanks = 4; xlCellTypeConstants = 2; xlCellTypeFormulas = $ FFFFEFE5; xlCellTypeLastCell = 11; xlCellTypeComments = $ FFFFEFD0; xlCellTypeVisible = 12; xlCellTypeAllFormatConditions = $ FFFFEFB4; xlCellTypeSameFormatConditions = $ FFFFEFB3; xlCellTypeAllValidation = $ FFFFEFB2; xlCellTypeSameValidation = $ FFFFEFB1; Enum XlArrangeStyle; xlArrangeStyleCascade = 7; xlArrangeStyleHorizontal = $ FFFFEFE0; xlArrangeStyleTiled = 1; xlArrangeStyleVertical = $ FFFFEFBA; Enum XlMousePointer; xlIBeam = 3; xlDefault = $ FFFFEFD1; xlNorthwestArrow = 1; xlWait = 2; Enum XlEditionOptionsOption; xlAutomaticUpdate = 4; xlCancel = 1; xlChangeAttributes = 6; xlManualUpdate = 5; xlOpenSource = 3; xlSelect = 3; xlSendPublisher = 2; xlUpdateSubscriber = 2; Enum XlAutoFillType; xlFillCopy = 1; xlFillDays = 5; xlFillDefault = 0; xlFillFormats = 3; xlFillMonths = 7; xlFillSeries = 2; xlFillValues = 4; xlFillWeekdays = 6; xlFillYears = 8; xlGrowthTrend = 10; xlLinearTrend = 9; Enum XlAutoFilterOperator; xlAnd = 1; xlBottom10Items = 4; xlBottom10Percent = 6; xlOr = 2; xlTop10Items = 3; xlTop10Percent = 5; 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; Enum XlFileFormat; xlAddIn = 18; xlCSV = 6; xlCSVMac = 22; xlCSVMSDOS = 24; xlCSVWindows = 23; xlDBF2 = 7; xlDBF3 = 8; xlDBF4 = 11; xlDIF = 9; xlExcel2 = 16; xlExcel2FarEast = 27; xlExcel3 = 29; xlExcel4 = 33; xlExcel5 = 39; xlExcel7 = 39; xlExcel9795 = 43; xlExcel4Workbook = 35; xlIntlAddIn = 26; xlIntlMacro = 25; xlWorkbookNormal = $ FFFFEFD1; xlSYLK = 2; xlTemplate = 17; xlCurrentPlatformText = $ FFFFEFC2; xlTextMac = 19; xlTextMSDOS = 21; xlTextPrinter = 36; xlTextWindows = 20; xlWJ2WD1 = 14; xlWK1 = 5; xlWK1ALL = 31; xlWK1FMT = 30; xlWK3 = 15; xlWK4 = 38; xlWK3FM3 = 32; xlWKS = 4; xlWorks2FarEast = 28; xlWQ1 = 34; xlWJ3 = 40; xlWJ3FJ3 = 41; xlUnicodeText = 42; xlHtml = 44; 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; Enum XlPageBreakExtent; xlPageBreakFull = 1; xlPageBreakPartial = 2; Enum XlCellInsertionMode; xlOverwriteCells = 0; xlInsertDeleteCells = 1; xlInsertEntireRows = 2; Enum XlFormulaLabel; xlNoLabels = $ FFFFEFD2; xlRowLabels = 1; xlColumnLabels = 2; xlMixedLabels = 3; Enum XlHighlightChangesTime; xlSinceMyLastSave = 1; xlAllChanges = 2; xlNotYetReviewed = 3; Enum XlCommentDisplayMode; xlNoIndicator = 0; xlCommentIndicatorOnly = -1; xlCommentAndIndicator = 1; Enum XlFormatConditionType; xlCellValue = 1; xlExpression = 2; Enum XlFormatConditionOperator; xlBetween = 1; xlNotBetween = 2; xlEqual = 3; xlNotEqual = 4; xlGreater = 5; xlLess = 6; xlGreaterEqual = 7; xlLessEqual = 8; Enum XlEnableSelection; xlNoRestrictions = 0; xlUnlockedCells = 1; xlNoSelection = $ FFFFEFD2; Enum XlDVType; xlValidateInputOnly = 0; xlValidateWholeNumber = 1; xlValidateDecimal = 2; xlValidateList = 3; xlValidateDate = 4; xlValidateTime = 5; xlValidateTextLength = 6; xlValidateCustom = 7; Enum XlIMEMode; xlIMEModeNoControl = 0; xlIMEModeOn = 1; xlIMEModeOff = 2; xlIMEModeDisable = 3; xlIMEModeHiragana = 4; xlIMEModeKatakana = 5; xlIMEModeKatakanaHalf = 6; xlIMEModeAlphaFull = 7; xlIMEModeAlpha = 8; xlIMEModeHangulFull = 9; xlIMEModeHangul = 10; Enum XlDVAlertStyle; xlValidAlertStop = 1; xlValidAlertWarning = 2; xlValidAlertInformation = 3; Enum XlChartLocation; xlLocationAsNewSheet = 1; xlLocationAsObject = 2; xlLocationAutomatic = 3; 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 = $ 100; Enum XlPasteSpecialOperation; xlPasteSpecialOperationAdd = 2; xlPasteSpecialOperationDivide = 5; xlPasteSpecialOperationMultiply = 4; xlPasteSpecialOperationNone = $ FFFFEFD2; xlPasteSpecialOperationSubtract = 3; Enum XlPasteType; xlPasteAll = $ FFFFEFF8; xlPasteAllExceptBorders = 7; xlPasteFormats = $ FFFFEFE6; xlPasteFormulas = $ FFFFEFE5; xlPasteComments = $ FFFFEFD0; xlPasteValues = $ FFFFEFBD; Enum XlPhoneticCharacterType; xlKatakanaHalf = 0; xlKatakana = 1; xlHiragana = 2; xlNoConversion = 3; Enum XlPhoneticAlignment; xlPhoneticAlignNoControl = 0; xlPhoneticAlignLeft = 1; xlPhoneticAlignCenter = 2; xlPhoneticAlignDistributed = 3; Enum XlPictureAppearance; xlPrinter = 2; xlScreen = 1; Enum XlPivotFieldOrientation; xlColumnField = 2; xlDataField = 4; xlHidden = 0; xlPageField = 3; xlRowField = 1; Enum XlPivotFieldCalculation; xlDifferenceFrom = 2; xlIndex = 9; xlNoAdditionalCalculation = $ FFFFEFD1; xlPercentDifferenceFrom = 4; xlPercentOf = 3; xlPercentOfColumn = 7; xlPercentOfRow = 6; xlPercentOfTotal = 8; xlRunningTotal = 5; Enum XlPlacement; xlFreeFloating = 3; xlMove = 2; xlMoveAndSize = 1; Enum XlPlatform; xlMacintosh = 1; xlMSDOS = 3; xlWindows = 2; Enum XlPrintLocation; xlPrintSheetEnd = 1; xlPrintInPlace = 16; xlPrintNoComments = $ FFFFEFD2; Enum XlPriority; xlPriorityHigh = $ FFFFEFE1; xlPriorityLow = $ FFFFEFDA; xlPriorityNormal = $ FFFFEFD1; Enum XlPTSelectionMode; xlLabelOnly = 1; xlDataAndLabel = 0; xlDataOnly = 2; xlOrigin = 3; xlButton = 15; xlBlanks = 4; xlFirstRow = $ 100; Enum XlRangeAutoFormat; xlRangeAutoFormat3DEffects1 = 13; xlRangeAutoFormat3DEffects2 = 14; xlRangeAutoFormatAccounting1 = 4; xlRangeAutoFormatAccounting2 = 5; xlRangeAutoFormatAccounting3 = 6; xlRangeAutoFormatAccounting4 = 17; xlRangeAutoFormatClassic1 = 1; xlRangeAutoFormatClassic2 = 2; xlRangeAutoFormatClassic3 = 3; xlRangeAutoFormatColor1 = 7; xlRangeAutoFormatColor2 = 8; xlRangeAutoFormatColor3 = 9; xlRangeAutoFormatList1 = 10; xlRangeAutoFormatList2 = 11; xlRangeAutoFormatList3 = 12; xlRangeAutoFormatLocalFormat1 = 15; xlRangeAutoFormatLocalFormat2 = 16; xlRangeAutoFormatLocalFormat3 = 19; xlRangeAutoFormatLocalFormat4 = 20; xlRangeAutoFormatReport1 = 21; xlRangeAutoFormatReport2 = 22; xlRangeAutoFormatReport3 = 23; xlRangeAutoFormatReport4 = 24; xlRangeAutoFormatReport5 = 25; xlRangeAutoFormatReport6 = 26; xlRangeAutoFormatReport7 = 27; xlRangeAutoFormatReport8 = 28; xlRangeAutoFormatReport9 = 29; xlRangeAutoFormatReport10 = 30; xlRangeAutoFormatClassicPivotTable = 31; xlRangeAutoFormatTable1 = 32; xlRangeAutoFormatTable2 = 33; xlRangeAutoFormatTable3 = 34; xlRangeAutoFormatTable4 = 35; xlRangeAutoFormatTable5 = 36; xlRangeAutoFormatTable6 = 37; xlRangeAutoFormatTable7 = 38; xlRangeAutoFormatTable8 = 39; xlRangeAutoFormatTable9 = 40; xlRangeAutoFormatTable10 = 41; xlRangeAutoFormatPTNone = 42; xlRangeAutoFormatNone = $ FFFFEFD2; xlRangeAutoFormatSimple = $ FFFFEFC6; Enum XlReferenceType; xlAbsolute = 1; xlAbsRowRelColumn = 2; xlRelative = 4; xlRelRowAbsColumn = 3; Enum XlLayoutFormType; xlTabular = 0; xlOutline = 1; Enum XlRoutingSlipDelivery; xlAllAtOnce = 2; xlOneAfterAnother = 1; Enum XlRoutingSlipStatus; xlNotYetRouted = 0; xlRoutingComplete = 2; xlRoutingInProgress = 1; Enum XlRunAutoMacro; xlAutoActivate = 3; xlAutoClose = 2; xlAutoDeactivate = 4; xlAutoOpen = 1; Enum XlSaveAction; xlDoNotSaveChanges = 2; xlSaveChanges = 1; Enum XlSaveAsAccessMode; xlExclusive = 3; xlNoChange = 1; xlShared = 2; Enum XlSaveConflictResolution; xlLocalSessionChanges = 2; xlOtherSessionChanges = 3; xlUserResolution = 1; Enum XlSearchDirection; xlNext = 1; xlPrevious = 2; Enum XlSearchOrder; xlByColumns = 2; xlByRows = 1; Enum XlSheetVisibility; xlSheetVisible = -1; xlSheetHidden = 0; xlSheetVeryHidden = 2; Enum XlSortMethod; xlPinYin = 1; xlStroke = 2; Enum XlSortMethodOld; xlCodePage = 2; xlSyllabary = 1; Enum XlSortOrder; xlAscending = 1; xlDescending = 2; Enum XlSortOrientation; xlSortRows = 2; xlSortColumns = 1; Enum XlSortType; xlSortLabels = 2; xlSortValues = 1; Enum XlSpecialCellsValue; xlErrors = 16; xlLogical = 4; xlNumbers = 1; xlTextValues = 2; Enum XlSubscribeToFormat; xlSubscribeToPicture = $ FFFFEFCD; xlSubscribeToText = $ FFFFEFC2; Enum XlSummaryRow; xlSummaryAbove = 0; xlSummaryBelow = 1; Enum XlSummaryColumn; xlSummaryOnLeft = $ FFFFEFDD; xlSummaryOnRight = $ FFFFEFC8; Enum XlSummaryReportType; xlSummaryPivotTable = $ FFFFEFCC; xlStandardSummary = 1; Enum XlTabPosition; xlTabPositionFirst = 0; xlTabPositionLast = 1; Enum XlTextParsingType; xlDelimited = 1; xlFixedWidth = 2; Enum XlTextQualifier; xlTextQualifierDoubleQuote = 1; xlTextQualifierNone = $ FFFFEFD2; xlTextQualifierSingleQuote = 2; Enum XlWBATemplate; xlWBATChart = $ FFFFEFF3; xlWBATExcel4IntlMacroSheet = 4; xlWBATExcel4MacroSheet = 3; xlWBATWorksheet = $ FFFFEFB9; Enum XlWindowView; xlNormalView = 1; xlPageBreakPreview = 2; Enum XlXLMMacroType; xlCommand = 2; xlFunction = 1; xlNotXLM = 3; Enum XlYesNoGuess; xlGuess = 0; xlNo = 2; xlYes = 1; Enum XlBordersIndex; xlInsideHorizontal = 12; xlInsideVertical = 11; xlDiagonalDown = 5; xlDiagonalUp = 6; xlEdgeBottom = 9; xlEdgeLeft = 7; xlEdgeRight = 10; xlEdgeTop = 8; Enum XlToolbarProtection; xlNoButtonChanges = 1; xlNoChanges = 4; xlNoDockingChanges = 3; xlToolbarProtectionNone = $ FFFFEFD1; xlNoShapeChanges = 2; Enum XlBuiltInDialog; xlDialogOpen = 1; xlDialogOpenLinks = 2; xlDialogSaveAs = 5; xlDialogFileDelete = 6; xlDialogPageSetup = 7; xlDialogPrint = 8; xlDialogPrinterSetup = 9; xlDialogArrangeAll = 12; xlDialogWindowSize = 13; xlDialogWindowMove = 14; xlDialogRun = 17; xlDialogSetPrintTitles = 23; xlDialogFont = 26; xlDialogDisplay = 27; xlDialogProtectDocument = 28; xlDialogCalculation = 32; xlDialogExtract = 35; xlDialogDataDelete = 36; xlDialogSort = 39; xlDialogDataSeries = 40; xlDialogTable = 41; xlDialogFormatNumber = 42; xlDialogAlignment = 43; xlDialogStyle = 44; xlDialogBorder = 45; xlDialogCellProtection = 46; xlDialogColumnWidth = 47; xlDialogClear = 52; xlDialogPasteSpecial = 53; xlDialogEditDelete = 54; xlDialogInsert = 55; xlDialogPasteNames = 58; xlDialogDefineName = 61; xlDialogCreateNames = 62; xlDialogFormulaGoto = 63; xlDialogFormulaFind = 64; xlDialogGalleryArea = 67; xlDialogGalleryBar = 68; xlDialogGalleryColumn = 69; xlDialogGalleryLine = 70; xlDialogGalleryPie = 71; xlDialogGalleryScatter = 72; xlDialogCombination = 73; xlDialogGridlines = 76; xlDialogAxes = 78; xlDialogAttachText = 80; xlDialogPatterns = 84; xlDialogMainChart = 85; xlDialogOverlay = 86; xlDialogScale = 87; xlDialogFormatLegend = 88; xlDialogFormatText = 89; xlDialogParse = 91; xlDialogUnhide = 94; xlDialogWorkspace = 95; xlDialogActivate = 103; xlDialogCopyPicture = 108; xlDialogDeleteName = 110; xlDialogDeleteFormat = 111; xlDialogNew = 119; xlDialogRowHeight = 127; xlDialogFormatMove = 128; xlDialogFormatSize = 129; xlDialogFormulaReplace = 130; xlDialogSelectSpecial = 132; xlDialogApplyNames = 133; xlDialogReplaceFont = 134; xlDialogSplit = 137; xlDialogOutline = 142; xlDialogSaveWorkbook = 145; xlDialogCopyChart = 147; xlDialogFormatFont = 150; xlDialogNote = 154; xlDialogSetUpdateStatus = 159; xlDialogColorPalette = 161; xlDialogChangeLink = 166; xlDialogAppMove = 170; xlDialogAppSize = 171; xlDialogMainChartType = 185; xlDialogOverlayChartType = 186; xlDialogOpenMail = 188; xlDialogSendMail = 189; xlDialogStandardFont = 190; xlDialogConsolidate = 191; xlDialogSortSpecial = 192; xlDialogGallery3dArea = 193; xlDialogGallery3dColumn = 194; xlDialogGallery3dLine = 195; xlDialogGallery3dPie = 196; xlDialogView3d = 197; xlDialogGoalSeek = 198; xlDialogWorkgroup = 199; xlDialogFillGroup = 200; xlDialogUpdateLink = 201; xlDialogPromote = 202; xlDialogDemote = 203; xlDialogShowDetail = 204; xlDialogObjectProperties = 207; xlDialogSaveNewObject = 208; xlDialogApplyStyle = 212; xlDialogAssignToObject = 213; xlDialogObjectProtection = 214; xlDialogCreatePublisher = 217; xlDialogSubscribeTo = 218; xlDialogShowToolbar = 220; xlDialogPrintPreview = 222; xlDialogEditColor = 223; xlDialogFormatMain = 225; xlDialogFormatOverlay = 226; xlDialogEditSeries = 228; xlDialogDefineStyle = 229; xlDialogGalleryRadar = 249; xlDialogEditionOptions = 251; xlDialogZoom = $ 100; xlDialogInsertObject = $ 103; xlDialogSize = $ 105; xlDialogMove = $ 106; xlDialogFormatAuto = $ 10D; xlDialogGallery3dBar = $ 110; xlDialogGallery3dSurface = $ 111; xlDialogCustomizeToolbar = $ 114; xlDialogWorkbookAdd = $ 119; xlDialogWorkbookMove = $ 11A; xlDialogWorkbookCopy = $ 11B; xlDialogWorkbookOptions = $ 11C; xlDialogSaveWorkspace = $ 11D; xlDialogChartWizard = $ 120; xlDialogAssignToTool = $ 125; xlDialogPlacement = $ 12C; xlDialogFillWorkgroup = $ 12D; xlDialogWorkbookNew = $ 12E; xlDialogScenarioCells = $ 131; xlDialogScenarioAdd = $ 133; xlDialogScenarioEdit = $ 134; xlDialogScenarioSummary = $ 137; xlDialogPivotTableWizard = $ 138; xlDialogPivotFieldProperties = $ 139; xlDialogOptionsCalculation = $ 13E; xlDialogOptionsEdit = $ 13F; xlDialogOptionsView = $ 140; xlDialogAddinManager = $ 141; xlDialogMenuEditor = $ 142; xlDialogAttachToolbars = $ 143; xlDialogOptionsChart = $ 145; xlDialogVbaInsertFile = $ 148; xlDialogVbaProcedureDefinition = $ 14A; xlDialogRoutingSlip = $ 150; xlDialogMailLogon = $ 153; xlDialogInsertPicture = $ 156; xlDialogGalleryDoughnut = $ 158; xlDialogChartTrend = $ 15E; xlDialogWorkbookInsert = $ 162; xlDialogOptionsTransition = $ 163; xlDialogOptionsGeneral = $ 164; xlDialogFilterAdvanced = $ 172; xlDialogMailNextLetter = $ 17A; xlDialogDataLabel = $ 17B; xlDialogInsertTitle = $ 17C; xlDialogFontProperties = $ 17D; xlDialogMacroOptions = $ 17E; xlDialogWorkbookUnhide = $ 180; xlDialogWorkbookName = $ 182; xlDialogGalleryCustom = $ 184; xlDialogAddChartAutoformat = $ 186; xlDialogChartAddData = $ 188; xlDialogTabOrder = $ 18A; xlDialogSubtotalCreate = $ 18E; xlDialogWorkbookTabSplit = $ 19F; xlDialogWorkbookProtect = $ 1A1; xlDialogScrollbarProperties = $ 1A4; xlDialogPivotShowPages = $ 1A5; xlDialogTextToColumns = $ 1A6; xlDialogFormatCharttype = $ 1A7; xlDialogPivotFieldGroup = $ 1B1; xlDialogPivotFieldUngroup = $ 1B2; xlDialogCheckboxProperties = $ 1B3; xlDialogLabelProperties = $ 1B4; xlDialogListboxProperties = $ 1B5; xlDialogEditboxProperties = $ 1B6; xlDialogOpenText = $ 1B9; xlDialogPushbuttonProperties = $ 1BD; xlDialogFilter = $ 1BF; xlDialogFunctionWizard = $ 1C2; xlDialogSaveCopyAs = $ 1C8; xlDialogOptionsListsAdd = $ 1CA; xlDialogSeriesAxes = $ 1CC; xlDialogSeriesX = $ 1CD; xlDialogSeriesY = $ 1CE; xlDialogErrorbarX = $ 1CF; xlDialogErrorbarY = $ 1D0; xlDialogFormatChart = $ 1D1; xlDialogSeriesOrder = $ 1D2; xlDialogMailEditMailer = $ 1D6; xlDialogStandardWidth = $ 1D8; xlDialogScenarioMerge = $ 1D9; xlDialogProperties = $ 1DA; xlDialogSummaryInfo = $ 1DA; xlDialogFindFile = $ 1DB; xlDialogActiveCellFont = $ 1DC; xlDialogVbaMakeAddin = $ 1DE; xlDialogFileSharing = $ 1E1; xlDialogAutoCorrect = $ 1E5; xlDialogCustomViews = $ 1ED; xlDialogInsertNameLabel = $ 1F0; xlDialogSeriesShape = $ 1F8; xlDialogChartOptionsDataLabels = $ 1F9; xlDialogChartOptionsDataTable = $ 1FA; xlDialogSetBackgroundPicture = $ 1FD; xlDialogDataValidation = $ 20D; xlDialogChartType = $ 20E; xlDialogChartLocation = $ 20F; _xlDialogPhonetic = $ 21A; xlDialogChartSourceData = $ 21C; _xlDialogChartSourceData = $ 21D; xlDialogSeriesOptions = $ 22D; xlDialogPivotTableOptions = $ 237; xlDialogPivotSolveOrder = $ 238; xlDialogPivotCalculatedField = $ 23A; xlDialogPivotCalculatedItem = $ 23C; xlDialogConditionalFormatting = $ 247; xlDialogInsertHyperlink = $ 254; xlDialogProtectSharing = $ 26C; xlDialogOptionsME = $ 287; xlDialogPublishAsWebPage = $ 28D; xlDialogPhonetic = $ 290; xlDialogNewWebQuery = $ 29B; xlDialogImportTextFile = $ 29A; xlDialogExternalDataProperties = $ 212; xlDialogWebOptionsGeneral = $ 2AB; xlDialogWebOptionsFiles = $ 2AC; xlDialogWebOptionsPictures = $ 2AD; xlDialogWebOptionsEncoding = $ 2AE; xlDialogWebOptionsFonts = $ 2AF; xlDialogPivotClientServerSet = $ 2B1; Enum XlParameterType; xlPrompt = 0; xlConstant = 1; xlRange = 2; Enum XlParameterDataType; xlParamTypeUnknown = 0; xlParamTypeChar = 1; xlParamTypeNumeric = 2; xlParamTypeDecimal = 3; xlParamTypeInteger = 4; xlParamTypeSmallInt = 5; xlParamTypeFloat = 6; xlParamTypeReal = 7; xlParamTypeDouble = 8; xlParamTypeVarChar = 12; xlParamTypeDate = 9; xlParamTypeTime = 10; xlParamTypeTimestamp = 11; xlParamTypeLongVarChar = -1; xlParamTypeBinary = -2; xlParamTypeVarBinary = -3; xlParamTypeLongVarBinary = -4; xlParamTypeBigInt = -5; xlParamTypeTinyInt = -6; xlParamTypeBit = -7; xlParamTypeWChar = -8; Enum XlFormControl; xlButtonControl = 0; xlCheckBox = 1; xlDropDown = 2; xlEditBox = 3; xlGroupBox = 4; xlLabel = 5; xlListBox = 6; xlOptionButton = 7; xlScrollBar = 8; xlSpinner = 9; Enum XlSourceType; xlSourceSheet = 1; xlSourcePrintArea = 2; xlSourceAutoFilter = 3; xlSourceRange = 4; xlSourceChart = 5; xlSourcePivotTable = 6; xlSourceQuery = 7; Enum XlHtmlType; xlHtmlStatic = 0; xlHtmlCalc = 1; xlHtmlList = 2; xlHtmlChart = 3; Enum xlPivotFormatType; xlReport1 = 0; xlReport2 = 1; xlReport3 = 2; xlReport4 = 3; xlReport5 = 4; xlReport6 = 5; xlReport7 = 6; xlReport8 = 7; xlReport9 = 8; xlReport10 = 9; xlTable1 = 10; xlTable2 = 11; xlTable3 = 12; xlTable4 = 13; xlTable5 = 14; xlTable6 = 15; xlTable7 = 16; xlTable8 = 17; xlTable9 = 18; xlTable10 = 19; xlPTClassic = 20; xlPTNone = 21; Enum XlCmdType; xlCmdCube = 1; xlCmdSql = 2; xlCmdTable = 3; xlCmdDefault = 4; Enum xlColumnDataType; xlGeneralFormat = 1; xlTextFormat = 2; xlMDYFormat = 3; xlDMYFormat = 4; xlYMDFormat = 5; xlMYDFormat = 6; xlDYMFormat = 7; xlYDMFormat = 8; xlSkipColumn = 9; xlEMDFormat = 10; Enum xlQueryType; xlODBCQuery = 1; xlDAORecordSet = 2; xlWebQuery = 4; xlOLEDBQuery = 5; xlTextImport = 6; xlADORecordset = 7; Enum xlWebSelectionType; xlEntirePage = 1; xlAllTables = 2; xlSpecifiedTables = 3; Enum XlCubeFieldType; xlHierarchy = 1; xlMeasure = 2; Enum xlWebFormatting; xlWebFormattingAll = 1; xlWebFormattingRTF = 2; xlWebFormattingNone = 3; Enum xlDisplayDrawingObjects; xlDisplayShapes = $ FFFFEFF8; xlHide = 3; xlPlaceholders = 2; Enum xLSubtototalLocationType; xlAtTop = 1; xlAtBottom = 2;