Option Compare Database Option Explicit 'global Consts for Excel, late binding, CutCopyMode Global Const xlCopy As Long = 1 Global Const xlCut As Long = 2 'global Consts for Outlook mail components Global Const gcolMailItem As Long = 0 'global Consts for Excel late binding, dialog box ''unable to find in list od Excel constants Global Const gcmsoFileDialogPicker As Long = 3 Global Const gcmsoFileDialogFolderPicker As Long = 4 'global Consts for Excel late binding, format color Global Const gcvbBlack As Long = 1 Global Const gcvbGray As Long = 15 Global Const gcvbWhite As Long = 16777215 Global Const gcvbBlue As Long = 5 Global Const gcvbNavy As Long = 11 ''global Consts for Excel late binding, page setup ''unable to find in list od Excel constants Global Const gcxlContext As Long = -5002 'Microsoft Excel Const: XlApplicationInternational Global Const gcxl24HourClock As Long = 33 Global Const gcxl4DigitYears As Long = 43 Global Const gcxlAlternateArraySeparator As Long = 16 Global Const gcxlColumnSeparator As Long = 14 Global Const gcxlCountryCode As Long = 1 Global Const gcxlCountrySetting As Long = 2 Global Const gcxlCurrencyBefore As Long = 37 Global Const gcxlCurrencyCode As Long = 25 Global Const gcxlCurrencyDigits As Long = 27 Global Const gcxlCurrencyLeadingZeros As Long = 40 Global Const gcxlCurrencyMinusSign As Long = 38 Global Const gcxlCurrencyNegative As Long = 28 Global Const gcxlCurrencySpaceBefore As Long = 36 Global Const gcxlCurrencyTrailingZeros As Long = 39 Global Const gcxlDateOrder As Long = 32 Global Const gcxlDateSeparator As Long = 17 Global Const gcxlDayCode As Long = 21 Global Const gcxlDayLeadingZero As Long = 42 Global Const gcxlDecimalSeparator As Long = 3 Global Const gcxlGeneralFormatName As Long = 26 Global Const gcxlHourCode As Long = 22 Global Const gcxlLeftBrace As Long = 12 Global Const gcxlLeftBracket As Long = 10 Global Const gcxlListSeparator As Long = 5 Global Const gcxlLowerCaseColumnLetter As Long = 9 Global Const gcxlLowerCaseRowLetter As Long = 8 Global Const gcxlMDY As Long = 44 Global Const gcxlMetric As Long = 35 Global Const gcxlMinuteCode As Long = 23 Global Const gcxlMonthCode As Long = 20 Global Const gcxlMonthLeadingZero As Long = 41 Global Const gcxlMonthNameChars As Long = 30 Global Const gcxlNoncurrencyDigits As Long = 29 Global Const gcxlNonEnglishFunctions As Long = 34 Global Const gcxlRightBrace As Long = 13 Global Const gcxlRightBracket As Long = 11 Global Const gcxlRowSeparator As Long = 15 Global Const gcxlSecondCode As Long = 24 Global Const gcxlThousandsSeparator As Long = 4 Global Const gcxlTimeLeadingZero As Long = 45 Global Const gcxlTimeSeparator As Long = 18 Global Const gcxlUpperCaseColumnLetter As Long = 7 Global Const gcxlUpperCaseRowLetter As Long = 6 Global Const gcxlWeekdayNameChars As Long = 31 Global Const gcxlYearCode As Long = 19 'Microsoft Excel Const: XlApplyNamesOrder Global Const gcxlColumnThenRow As Long = 2 Global Const gcxlRowThenColumn As Long = 1 'Microsoft Excel Const: XlArabicModes Global Const gcxlArabicBothStrict As Long = 3 Global Const gcxlArabicNone As Long = 0 Global Const gcxlArabicStrictAlefHamza As Long = 1 Global Const gcxlArabicStrictFinalYaa As Long = 2 'Microsoft Excel Const: XlArrangeStyle Global Const gcxlArrangeStyleCascade As Long = 7 Global Const gcxlArrangeStyleHorizontal As Long = -4128 Global Const gcxlArrangeStyleTiled As Long = 1 Global Const gcxlArrangeStyleVertical As Long = -4166 'Microsoft Excel Const: XlArrowHeadLength Global Const gcxlArrowHeadLengthLong As Long = 3 Global Const gcxlArrowHeadLengthMedium As Long = -4138 Global Const gcxlArrowHeadLengthShort As Long = 1 'Microsoft Excel Const: XlArrowHeadStyle Global Const gcxlArrowHeadStyleClosed As Long = 3 Global Const gcxlArrowHeadStyleDoubleClosed As Long = 5 Global Const gcxlArrowHeadStyleDoubleOpen As Long = 4 Global Const gcxlArrowHeadStyleNone As Long = -4142 Global Const gcxlArrowHeadStyleOpen As Long = 2 'Microsoft Excel Const: XlArrowHeadWidth Global Const gcxlArrowHeadWidthMedium As Long = -4138 Global Const gcxlArrowHeadWidthNarrow As Long = 1 Global Const gcxlArrowHeadWidthWide As Long = 3 'Microsoft Excel Const: XlAutoFillType Global Const gcxlFillCopy As Long = 1 Global Const gcxlFillDays As Long = 5 Global Const gcxlFillDefault As Long = 0 Global Const gcxlFillFormats As Long = 3 Global Const gcxlFillMonths As Long = 7 Global Const gcxlFillSeries As Long = 2 Global Const gcxlFillValues As Long = 4 Global Const gcxlFillWeekdays As Long = 6 Global Const gcxlFillYears As Long = 8 Global Const gcxlGrowthTrend As Long = 10 Global Const gcxlLinearTrend As Long = 9 'Microsoft Excel Const: XlAutoFilterOperator Global Const gcxlAnd As Long = 1 Global Const gcxlBottom10Items As Long = 4 Global Const gcxlBottom10Percent As Long = 6 Global Const gcxlOr As Long = 2 Global Const gcxlTop10Items As Long = 3 Global Const gcxlTop10Percent As Long = 5 'Microsoft Excel Const: XlAxisCrosses Global Const gcxlAxisCrossesAutomatic As Long = -4105 Global Const gcxlAxisCrossesCustom As Long = -4114 Global Const gcxlAxisCrossesMaximum As Long = 2 Global Const gcxlAxisCrossesMinimum As Long = 4 'Microsoft Excel Const: XlAxisGroup Global Const gcxlPrimary As Long = 1 Global Const gcxlSecondary As Long = 2 'Microsoft Excel Const: XlAxisType Global Const gcxlCategory As Long = 1 Global Const gcxlSeriesAxis As Long = 3 Global Const gcxlValue As Long = 2 'Microsoft Excel Const: XlBackground Global Const gcxlBackgroundAutomatic As Long = -4105 Global Const gcxlBackgroundOpaque As Long = 3 Global Const gcxlBackgroundTransparent As Long = 2 'Microsoft Excel Const: XlBarShape Global Const gcxlBox As Long = 0 Global Const gcxlConeToMax As Long = 5 Global Const gcxlConeToPoint As Long = 4 Global Const gcxlCylinder As Long = 3 Global Const gcxlPyramidToMax As Long = 2 Global Const gcxlPyramidToPoint As Long = 1 'Microsoft Excel Const: XlBordersIndex Global Const gcxlDiagonalDown As Long = 5 Global Const gcxlDiagonalUp As Long = 6 Global Const gcxlEdgeBottom As Long = 9 Global Const gcxlEdgeLeft As Long = 7 Global Const gcxlEdgeRight As Long = 10 Global Const gcxlEdgeTop As Long = 8 Global Const gcxlInsideHorizontal As Long = 12 Global Const gcxlInsideVertical As Long = 11 'Microsoft Excel Const: XlBorderWeight Global Const gcxlHairline As Long = 1 Global Const gcxlMedium As Long = -4138 Global Const gcxlThick As Long = 4 Global Const gcxlThin As Long = 2 'Microsoft Excel Const: XlBuiltInDialog Global Const gc_xlDialogChartSourceData As Long = 541 Global Const gc_xlDialogPhonetic As Long = 538 Global Const gcxlDialogActivate As Long = 103 Global Const gcxlDialogActiveCellFont As Long = 476 Global Const gcxlDialogAddChartAutoformat As Long = 390 Global Const gcxlDialogAddinManager As Long = 321 Global Const gcxlDialogAlignment As Long = 43 Global Const gcxlDialogApplyNames As Long = 133 Global Const gcxlDialogApplyStyle As Long = 212 Global Const gcxlDialogAppMove As Long = 170 Global Const gcxlDialogAppSize As Long = 171 Global Const gcxlDialogArrangeAll As Long = 12 Global Const gcxlDialogAssignToObject As Long = 213 Global Const gcxlDialogAssignToTool As Long = 293 Global Const gcxlDialogAttachText As Long = 80 Global Const gcxlDialogAttachToolbars As Long = 323 Global Const gcxlDialogAutoCorrect As Long = 485 Global Const gcxlDialogAxes As Long = 78 Global Const gcxlDialogBorder As Long = 45 Global Const gcxlDialogCalculation As Long = 32 Global Const gcxlDialogCellProtection As Long = 46 Global Const gcxlDialogChangeLink As Long = 166 Global Const gcxlDialogChartAddData As Long = 392 Global Const gcxlDialogChartLocation As Long = 527 Global Const gcxlDialogChartOptionsDataLabelMultiple As Long = 724 Global Const gcxlDialogChartOptionsDataLabels As Long = 505 Global Const gcxlDialogChartOptionsDataTable As Long = 506 Global Const gcxlDialogChartSourceData As Long = 540 Global Const gcxlDialogChartTrend As Long = 350 Global Const gcxlDialogChartType As Long = 526 Global Const gcxlDialogChartWizard As Long = 288 Global Const gcxlDialogCheckboxProperties As Long = 435 Global Const gcxlDialogClear As Long = 52 Global Const gcxlDialogColorPalette As Long = 161 Global Const gcxlDialogColumnWidth As Long = 47 Global Const gcxlDialogCombination As Long = 73 Global Const gcxlDialogConditionalFormatting As Long = 583 Global Const gcxlDialogConsolidate As Long = 191 Global Const gcxlDialogCopyChart As Long = 147 Global Const gcxlDialogCopyPicture As Long = 108 Global Const gcxlDialogCreateList As Long = 796 Global Const gcxlDialogCreateNames As Long = 62 Global Const gcxlDialogCreatePublisher As Long = 217 Global Const gcxlDialogCustomizeToolbar As Long = 276 Global Const gcxlDialogCustomViews As Long = 493 Global Const gcxlDialogDataDelete As Long = 36 Global Const gcxlDialogDataLabel As Long = 379 Global Const gcxlDialogDataLabelMultiple As Long = 723 Global Const gcxlDialogDataSeries As Long = 40 Global Const gcxlDialogDataValidation As Long = 525 Global Const gcxlDialogDefineName As Long = 61 Global Const gcxlDialogDefineStyle As Long = 229 Global Const gcxlDialogDeleteFormat As Long = 111 Global Const gcxlDialogDeleteName As Long = 110 Global Const gcxlDialogDemote As Long = 203 Global Const gcxlDialogDisplay As Long = 27 Global Const gcxlDialogEditboxProperties As Long = 438 Global Const gcxlDialogEditColor As Long = 223 Global Const gcxlDialogEditDelete As Long = 54 Global Const gcxlDialogEditionOptions As Long = 251 Global Const gcxlDialogEditSeries As Long = 228 Global Const gcxlDialogErrorbarX As Long = 463 Global Const gcxlDialogErrorbarY As Long = 464 Global Const gcxlDialogErrorChecking As Long = 732 Global Const gcxlDialogEvaluateFormula As Long = 709 Global Const gcxlDialogExternalDataProperties As Long = 530 Global Const gcxlDialogExtract As Long = 35 Global Const gcxlDialogFileDelete As Long = 6 Global Const gcxlDialogFileSharing As Long = 481 Global Const gcxlDialogFillGroup As Long = 200 Global Const gcxlDialogFillWorkgroup As Long = 301 Global Const gcxlDialogFilter As Long = 447 Global Const gcxlDialogFilterAdvanced As Long = 370 Global Const gcxlDialogFindFile As Long = 475 Global Const gcxlDialogFont As Long = 26 Global Const gcxlDialogFontProperties As Long = 381 Global Const gcxlDialogFormatAuto As Long = 269 Global Const gcxlDialogFormatChart As Long = 465 Global Const gcxlDialogFormatCharttype As Long = 423 Global Const gcxlDialogFormatFont As Long = 150 Global Const gcxlDialogFormatLegend As Long = 88 Global Const gcxlDialogFormatMain As Long = 225 Global Const gcxlDialogFormatMove As Long = 128 Global Const gcxlDialogFormatNumber As Long = 42 Global Const gcxlDialogFormatOverlay As Long = 226 Global Const gcxlDialogFormatSize As Long = 129 Global Const gcxlDialogFormatText As Long = 89 Global Const gcxlDialogFormulaFind As Long = 64 Global Const gcxlDialogFormulaGoto As Long = 63 Global Const gcxlDialogFormulaReplace As Long = 130 Global Const gcxlDialogFunctionWizard As Long = 450 Global Const gcxlDialogGallery3dArea As Long = 193 Global Const gcxlDialogGallery3dBar As Long = 272 Global Const gcxlDialogGallery3dColumn As Long = 194 Global Const gcxlDialogGallery3dLine As Long = 195 Global Const gcxlDialogGallery3dPie As Long = 196 Global Const gcxlDialogGallery3dSurface As Long = 273 Global Const gcxlDialogGalleryArea As Long = 67 Global Const gcxlDialogGalleryBar As Long = 68 Global Const gcxlDialogGalleryColumn As Long = 69 Global Const gcxlDialogGalleryCustom As Long = 388 Global Const gcxlDialogGalleryDoughnut As Long = 344 Global Const gcxlDialogGalleryLine As Long = 70 Global Const gcxlDialogGalleryPie As Long = 71 Global Const gcxlDialogGalleryRadar As Long = 249 Global Const gcxlDialogGalleryScatter As Long = 72 Global Const gcxlDialogGoalSeek As Long = 198 Global Const gcxlDialogGridlines As Long = 76 Global Const gcxlDialogImportTextFile As Long = 666 Global Const gcxlDialogInsert As Long = 55 Global Const gcxlDialogInsertHyperlink As Long = 596 Global Const gcxlDialogInsertNameLabel As Long = 496 Global Const gcxlDialogInsertObject As Long = 259 Global Const gcxlDialogInsertPicture As Long = 342 Global Const gcxlDialogInsertTitle As Long = 380 Global Const gcxlDialogLabelProperties As Long = 436 Global Const gcxlDialogListboxProperties As Long = 437 Global Const gcxlDialogMacroOptions As Long = 382 Global Const gcxlDialogMailEditMailer As Long = 470 Global Const gcxlDialogMailLogon As Long = 339 Global Const gcxlDialogMailNextLetter As Long = 378 Global Const gcxlDialogMainChart As Long = 85 Global Const gcxlDialogMainChartType As Long = 185 Global Const gcxlDialogMenuEditor As Long = 322 Global Const gcxlDialogMove As Long = 262 Global Const gcxlDialogMyPermission As Long = 834 Global Const gcxlDialogNew As Long = 119 Global Const gcxlDialogNewWebQuery As Long = 667 Global Const gcxlDialogNote As Long = 154 Global Const gcxlDialogObjectProperties As Long = 207 Global Const gcxlDialogObjectProtection As Long = 214 Global Const gcxlDialogOpen As Long = 1 Global Const gcxlDialogOpenLinks As Long = 2 Global Const gcxlDialogOpenMail As Long = 188 Global Const gcxlDialogOpenText As Long = 441 Global Const gcxlDialogOptionsCalculation As Long = 318 Global Const gcxlDialogOptionsChart As Long = 325 Global Const gcxlDialogOptionsEdit As Long = 319 Global Const gcxlDialogOptionsGeneral As Long = 356 Global Const gcxlDialogOptionsListsAdd As Long = 458 Global Const gcxlDialogOptionsME As Long = 647 Global Const gcxlDialogOptionsTransition As Long = 355 Global Const gcxlDialogOptionsView As Long = 320 Global Const gcxlDialogOutline As Long = 142 Global Const gcxlDialogOverlay As Long = 86 Global Const gcxlDialogOverlayChartType As Long = 186 Global Const gcxlDialogPageSetup As Long = 7 Global Const gcxlDialogParse As Long = 91 Global Const gcxlDialogPasteNames As Long = 58 Global Const gcxlDialogPasteSpecial As Long = 53 Global Const gcxlDialogPatterns As Long = 84 Global Const gcxlDialogPermission As Long = 832 Global Const gcxlDialogPhonetic As Long = 656 Global Const gcxlDialogPivotCalculatedField As Long = 570 Global Const gcxlDialogPivotCalculatedItem As Long = 572 Global Const gcxlDialogPivotClientServerSet As Long = 689 Global Const gcxlDialogPivotFieldGroup As Long = 433 Global Const gcxlDialogPivotFieldProperties As Long = 313 Global Const gcxlDialogPivotFieldUngroup As Long = 434 Global Const gcxlDialogPivotShowPages As Long = 421 Global Const gcxlDialogPivotSolveOrder As Long = 568 Global Const gcxlDialogPivotTableOptions As Long = 567 Global Const gcxlDialogPivotTableWizard As Long = 312 Global Const gcxlDialogPlacement As Long = 300 Global Const gcxlDialogPrint As Long = 8 Global Const gcxlDialogPrinterSetup As Long = 9 Global Const gcxlDialogPrintPreview As Long = 222 Global Const gcxlDialogPromote As Long = 202 Global Const gcxlDialogProperties As Long = 474 Global Const gcxlDialogPropertyFields As Long = 754 Global Const gcxlDialogProtectDocument As Long = 28 Global Const gcxlDialogProtectSharing As Long = 620 Global Const gcxlDialogPublishAsWebPage As Long = 653 Global Const gcxlDialogPushbuttonProperties As Long = 445 Global Const gcxlDialogReplaceFont As Long = 134 Global Const gcxlDialogRoutingSlip As Long = 336 Global Const gcxlDialogRowHeight As Long = 127 Global Const gcxlDialogRun As Long = 17 Global Const gcxlDialogSaveAs As Long = 5 Global Const gcxlDialogSaveCopyAs As Long = 456 Global Const gcxlDialogSaveNewObject As Long = 208 Global Const gcxlDialogSaveWorkbook As Long = 145 Global Const gcxlDialogSaveWorkspace As Long = 285 Global Const gcxlDialogScale As Long = 87 Global Const gcxlDialogScenarioAdd As Long = 307 Global Const gcxlDialogScenarioCells As Long = 305 Global Const gcxlDialogScenarioEdit As Long = 308 Global Const gcxlDialogScenarioMerge As Long = 473 Global Const gcxlDialogScenarioSummary As Long = 311 Global Const gcxlDialogScrollbarProperties As Long = 420 Global Const gcxlDialogSearch As Long = 731 Global Const gcxlDialogSelectSpecial As Long = 132 Global Const gcxlDialogSendMail As Long = 189 Global Const gcxlDialogSeriesAxes As Long = 460 Global Const gcxlDialogSeriesOptions As Long = 557 Global Const gcxlDialogSeriesOrder As Long = 466 Global Const gcxlDialogSeriesShape As Long = 504 Global Const gcxlDialogSeriesX As Long = 461 Global Const gcxlDialogSeriesY As Long = 462 Global Const gcxlDialogSetBackgroundPicture As Long = 509 Global Const gcxlDialogSetPrintTitles As Long = 23 Global Const gcxlDialogSetUpdateStatus As Long = 159 Global Const gcxlDialogShowDetail As Long = 204 Global Const gcxlDialogShowToolbar As Long = 220 Global Const gcxlDialogSize As Long = 261 Global Const gcxlDialogSort As Long = 39 Global Const gcxlDialogSortSpecial As Long = 192 Global Const gcxlDialogSplit As Long = 137 Global Const gcxlDialogStandardFont As Long = 190 Global Const gcxlDialogStandardWidth As Long = 472 Global Const gcxlDialogStyle As Long = 44 Global Const gcxlDialogSubscribeTo As Long = 218 Global Const gcxlDialogSubtotalCreate As Long = 398 Global Const gcxlDialogSummaryInfo As Long = 474 Global Const gcxlDialogTable As Long = 41 Global Const gcxlDialogTabOrder As Long = 394 Global Const gcxlDialogTextToColumns As Long = 422 Global Const gcxlDialogUnhide As Long = 94 Global Const gcxlDialogUpdateLink As Long = 201 Global Const gcxlDialogVbaInsertFile As Long = 328 Global Const gcxlDialogVbaMakeAddin As Long = 478 Global Const gcxlDialogVbaProcedureDefinition As Long = 330 Global Const gcxlDialogView3d As Long = 197 Global Const gcxlDialogWebOptionsBrowsers As Long = 773 Global Const gcxlDialogWebOptionsEncoding As Long = 686 Global Const gcxlDialogWebOptionsFiles As Long = 684 Global Const gcxlDialogWebOptionsFonts As Long = 687 Global Const gcxlDialogWebOptionsGeneral As Long = 683 Global Const gcxlDialogWebOptionsPictures As Long = 685 Global Const gcxlDialogWindowMove As Long = 14 Global Const gcxlDialogWindowSize As Long = 13 Global Const gcxlDialogWorkbookAdd As Long = 281 Global Const gcxlDialogWorkbookCopy As Long = 283 Global Const gcxlDialogWorkbookInsert As Long = 354 Global Const gcxlDialogWorkbookMove As Long = 282 Global Const gcxlDialogWorkbookName As Long = 386 Global Const gcxlDialogWorkbookNew As Long = 302 Global Const gcxlDialogWorkbookOptions As Long = 284 Global Const gcxlDialogWorkbookProtect As Long = 417 Global Const gcxlDialogWorkbookTabSplit As Long = 415 Global Const gcxlDialogWorkbookUnhide As Long = 384 Global Const gcxlDialogWorkgroup As Long = 199 Global Const gcxlDialogWorkspace As Long = 95 Global Const gcxlDialogZoom As Long = 256 'Microsoft Excel Const: XlCalculatedMemberType Global Const gcxlCalculatedMember As Long = 0 Global Const gcxlCalculatedSet As Long = 1 'Microsoft Excel Const: XlCalculation Global Const gcxlCalculationAutomatic As Long = -4105 Global Const gcxlCalculationManual As Long = -4135 Global Const gcxlCalculationSemiautomatic As Long = 2 'Microsoft Excel Const: XlCalculationInterruptKey Global Const gcxlAnyKey As Long = 2 Global Const gcxlEscKey As Long = 1 Global Const gcxlNoKey As Long = 0 'Microsoft Excel Const: XlCalculationState Global Const gcxlCalculating As Long = 1 Global Const gcxlDone As Long = 0 Global Const gcxlPending As Long = 2 'Microsoft Excel Const: XlCategoryType Global Const gcxlAutomaticScale As Long = -4105 Global Const gcxlCategoryScale As Long = 2 Global Const gcxlTimeScale As Long = 3 'Microsoft Excel Const: XlCellInsertionMode Global Const gcxlInsertDeleteCells As Long = 1 Global Const gcxlInsertEntireRows As Long = 2 Global Const gcxlOverwriteCells As Long = 0 'Microsoft Excel Const: XlCellType Global Const gcxlCellTypeAllFormatConditions As Long = -4172 Global Const gcxlCellTypeAllValidation As Long = -4174 Global Const gcxlCellTypeBlanks As Long = 4 Global Const gcxlCellTypeComments As Long = -4144 Global Const gcxlCellTypeConsts As Long = 2 Global Const gcxlCellTypeFormulas As Long = -4123 Global Const gcxlCellTypeLastCell As Long = 11 Global Const gcxlCellTypeSameFormatConditions As Long = -4173 Global Const gcxlCellTypeSameValidation As Long = -4175 Global Const gcxlCellTypeVisible As Long = 12 'Microsoft Excel Const: XlChartGallery Global Const gcxlAnyGallery As Long = 23 Global Const gcxlBuiltIn As Long = 21 Global Const gcxlUserDefined As Long = 22 'Microsoft Excel Const: XlChartItem Global Const gcxlAxis As Long = 21 Global Const gcxlAxisTitle As Long = 17 Global Const gcxlChartArea As Long = 2 Global Const gcxlChartTitle As Long = 4 Global Const gcxlCorners As Long = 6 Global Const gcxlDataLabel As Long = 0 Global Const gcxlDataTable As Long = 7 Global Const gcxlDisplayUnitLabel As Long = 30 Global Const gcxlDownBars As Long = 20 Global Const gcxlDropLines As Long = 26 Global Const gcxlErrorBars As Long = 9 Global Const gcxlFloor As Long = 23 Global Const gcxlHiLoLines As Long = 25 Global Const gcxlLeaderLines As Long = 29 Global Const gcxlLegend As Long = 24 Global Const gcxlLegendEntry As Long = 12 Global Const gcxlLegendKey As Long = 13 Global Const gcxlMajorGridlines As Long = 15 Global Const gcxlMinorGridlines As Long = 16 Global Const gcxlNothing As Long = 28 Global Const gcxlPivotChartDropZone As Long = 32 Global Const gcxlPivotChartFieldButton As Long = 31 Global Const gcxlPlotArea As Long = 19 Global Const gcxlRadarAxisLabels As Long = 27 Global Const gcxlSeries As Long = 3 Global Const gcxlSeriesLines As Long = 22 Global Const gcxlShape As Long = 14 Global Const gcxlTrendline As Long = 8 Global Const gcxlUpBars As Long = 18 Global Const gcxlWalls As Long = 5 Global Const gcxlXErrorBars As Long = 10 Global Const gcxlYErrorBars As Long = 11 'Microsoft Excel Const: XlChartLocation Global Const gcxlLocationAsNewSheet As Long = 1 Global Const gcxlLocationAsObject As Long = 2 Global Const gcxlLocationAutomatic As Long = 3 'Microsoft Excel Const: XlChartPicturePlacement Global Const gcxlAllFaces As Long = 7 Global Const gcxlEnd As Long = 2 Global Const gcxlEndSides As Long = 3 Global Const gcxlFront As Long = 4 Global Const gcxlFrontEnd As Long = 6 Global Const gcxlFrontSides As Long = 5 Global Const gcxlSides As Long = 1 'Microsoft Excel Const: XlChartPictureType Global Const gcxlStack As Long = 2 Global Const gcxlStackScale As Long = 3 Global Const gcxlStretch As Long = 1 'Microsoft Excel Const: XlChartSplitType Global Const gcxlSplitByCustomSplit As Long = 4 Global Const gcxlSplitByPercentValue As Long = 3 Global Const gcxlSplitByPosition As Long = 1 Global Const gcxlSplitByValue As Long = 2 'Microsoft Excel Const: XlChartType Global Const gcxl3DArea As Long = -4098 Global Const gcxl3DAreaStacked As Long = 78 Global Const gcxl3DAreaStacked100 As Long = 79 Global Const gcxl3DBarClustered As Long = 60 Global Const gcxl3DBarStacked As Long = 61 Global Const gcxl3DBarStacked100 As Long = 62 Global Const gcxl3DColumn As Long = -4100 Global Const gcxl3DColumnClustered As Long = 54 Global Const gcxl3DColumnStacked As Long = 55 Global Const gcxl3DColumnStacked100 As Long = 56 Global Const gcxl3DLine As Long = -4101 Global Const gcxl3DPie As Long = -4102 Global Const gcxl3DPieExploded As Long = 70 Global Const gcxlArea As Long = 1 Global Const gcxlAreaStacked As Long = 76 Global Const gcxlAreaStacked100 As Long = 77 Global Const gcxlBarClustered As Long = 57 Global Const gcxlBarOfPie As Long = 71 Global Const gcxlBarStacked As Long = 58 Global Const gcxlBarStacked100 As Long = 59 Global Const gcxlBubble As Long = 15 Global Const gcxlBubble3DEffect As Long = 87 Global Const gcxlColumnClustered As Long = 51 Global Const gcxlColumnStacked As Long = 52 Global Const gcxlColumnStacked100 As Long = 53 Global Const gcxlConeBarClustered As Long = 102 Global Const gcxlConeBarStacked As Long = 103 Global Const gcxlConeBarStacked100 As Long = 104 Global Const gcxlConeCol As Long = 105 Global Const gcxlConeColClustered As Long = 99 Global Const gcxlConeColStacked As Long = 100 Global Const gcxlConeColStacked100 As Long = 101 Global Const gcxlCylinderBarClustered As Long = 95 Global Const gcxlCylinderBarStacked As Long = 96 Global Const gcxlCylinderBarStacked100 As Long = 97 Global Const gcxlCylinderCol As Long = 98 Global Const gcxlCylinderColClustered As Long = 92 Global Const gcxlCylinderColStacked As Long = 93 Global Const gcxlCylinderColStacked100 As Long = 94 Global Const gcxlDoughnut As Long = -4120 Global Const gcxlDoughnutExploded As Long = 80 Global Const gcxlLine As Long = 4 Global Const gcxlLineMarkers As Long = 65 Global Const gcxlLineMarkersStacked As Long = 66 Global Const gcxlLineMarkersStacked100 As Long = 67 Global Const gcxlLineStacked As Long = 63 Global Const gcxlLineStacked100 As Long = 64 Global Const gcxlPie As Long = 5 Global Const gcxlPieExploded As Long = 69 Global Const gcxlPieOfPie As Long = 68 Global Const gcxlPyramidBarClustered As Long = 109 Global Const gcxlPyramidBarStacked As Long = 110 Global Const gcxlPyramidBarStacked100 As Long = 111 Global Const gcxlPyramidCol As Long = 112 Global Const gcxlPyramidColClustered As Long = 106 Global Const gcxlPyramidColStacked As Long = 107 Global Const gcxlPyramidColStacked100 As Long = 108 Global Const gcxlRadar As Long = -4151 Global Const gcxlRadarFilled As Long = 82 Global Const gcxlRadarMarkers As Long = 81 Global Const gcxlStockHLC As Long = 88 Global Const gcxlStockOHLC As Long = 89 Global Const gcxlStockVHLC As Long = 90 Global Const gcxlStockVOHLC As Long = 91 Global Const gcxlSurface As Long = 83 Global Const gcxlSurfaceTopView As Long = 85 Global Const gcxlSurfaceTopViewWireframe As Long = 86 Global Const gcxlSurfaceWireframe As Long = 84 Global Const gcxlXYScatter As Long = -4169 Global Const gcxlXYScatterLines As Long = 74 Global Const gcxlXYScatterLinesNoMarkers As Long = 75 Global Const gcxlXYScatterSmooth As Long = 72 Global Const gcxlXYScatterSmoothNoMarkers As Long = 73 'Microsoft Excel Const: XlClipboardFormat Global Const gcxlClipboardFormatBIFF As Long = 8 Global Const gcxlClipboardFormatBIFF2 As Long = 18 Global Const gcxlClipboardFormatBIFF3 As Long = 20 Global Const gcxlClipboardFormatBIFF4 As Long = 30 Global Const gcxlClipboardFormatBinary As Long = 15 Global Const gcxlClipboardFormatBitmap As Long = 9 Global Const gcxlClipboardFormatCGM As Long = 13 Global Const gcxlClipboardFormatCSV As Long = 5 Global Const gcxlClipboardFormatDIF As Long = 4 Global Const gcxlClipboardFormatDspText As Long = 12 Global Const gcxlClipboardFormatEmbeddedObject As Long = 21 Global Const gcxlClipboardFormatEmbedSource As Long = 22 Global Const gcxlClipboardFormatLink As Long = 11 Global Const gcxlClipboardFormatLinkSource As Long = 23 Global Const gcxlClipboardFormatLinkSourceDesc As Long = 32 Global Const gcxlClipboardFormatMovie As Long = 24 Global Const gcxlClipboardFormatNative As Long = 14 Global Const gcxlClipboardFormatObjectDesc As Long = 31 Global Const gcxlClipboardFormatObjectLink As Long = 19 Global Const gcxlClipboardFormatOwnerLink As Long = 17 Global Const gcxlClipboardFormatPICT As Long = 2 Global Const gcxlClipboardFormatPrintPICT As Long = 3 Global Const gcxlClipboardFormatRTF As Long = 7 Global Const gcxlClipboardFormatScreenPICT As Long = 29 Global Const gcxlClipboardFormatStandardFont As Long = 28 Global Const gcxlClipboardFormatStandardScale As Long = 27 Global Const gcxlClipboardFormatSYLK As Long = 6 Global Const gcxlClipboardFormatTable As Long = 16 Global Const gcxlClipboardFormatText As Long = 0 Global Const gcxlClipboardFormatToolFace As Long = 25 Global Const gcxlClipboardFormatToolFacePICT As Long = 26 Global Const gcxlClipboardFormatVALU As Long = 1 Global Const gcxlClipboardFormatWK1 As Long = 10 'Microsoft Excel Const: XlCmdType Global Const gcxlCmdCube As Long = 1 Global Const gcxlCmdDefault As Long = 4 Global Const gcxlCmdList As Long = 5 Global Const gcxlCmdSql As Long = 2 Global Const gcxlCmdTable As Long = 3 'Microsoft Excel Const: XlColorIndex Global Const gcxlColorIndexAutomatic As Long = -4105 Global Const gcxlColorIndexNone As Long = -4142 'Microsoft Excel Const: XlColumnDataType Global Const gcxlDMYFormat As Long = 4 Global Const gcxlDYMFormat As Long = 7 Global Const gcxlEMDFormat As Long = 10 Global Const gcxlGeneralFormat As Long = 1 Global Const gcxlMDYFormat As Long = 3 Global Const gcxlMYDFormat As Long = 6 Global Const gcxlSkipColumn As Long = 9 Global Const gcxlTextFormat As Long = 2 Global Const gcxlYDMFormat As Long = 8 Global Const gcxlYMDFormat As Long = 5 'Microsoft Excel Const: XlCommandUnderlines Global Const gcxlCommandUnderlinesAutomatic As Long = -4105 Global Const gcxlCommandUnderlinesOff As Long = -4146 Global Const gcxlCommandUnderlinesOn As Long = 1 'Microsoft Excel Const: XlCommentDisplayMode Global Const gcxlCommentAndIndicator As Long = 1 Global Const gcxlCommentIndicatorOnly As Long = -1 Global Const gcxlNoIndicator As Long = 0 'Microsoft Excel Const: XlConsolidationFunction Global Const gcxlAverage As Long = -4106 Global Const gcxlCount As Long = -4112 Global Const gcxlCountNums As Long = -4113 Global Const gcxlMax As Long = -4136 Global Const gcxlMin As Long = -4139 Global Const gcxlProduct As Long = -4149 Global Const gcxlStDev As Long = -4155 Global Const gcxlStDevP As Long = -4156 Global Const gcxlSum As Long = -4157 Global Const gcxlUnknown As Long = 1000 Global Const gcxlVar As Long = -4164 Global Const gcxlVarP As Long = -4165 'Microsoft Excel Const: XlCopyPictureFormat Global Const gcxlBitmap As Long = 2 Global Const gcxlPicture As Long = -4147 'Microsoft Excel Const: XlCorruptLoad Global Const gcxlExtractData As Long = 2 Global Const gcxlNormalLoad As Long = 0 Global Const gcxlRepairFile As Long = 1 'Microsoft Excel Const: XlCreator Global Const gcxlCreatorCode As Long = 1480803660 'Microsoft Excel Const: XlCubeFieldType Global Const gcxlHierarchy As Long = 1 Global Const gcxlMeasure As Long = 2 Global Const gcxlSet As Long = 3 'Microsoft Excel Const: XlCutCopyMode Global Const gcxlCopy As Long = 1 Global Const gcxlCut As Long = 2 'Microsoft Excel Const: XlCVError Global Const gcxlErrDiv0 As Long = 2007 Global Const gcxlErrNA As Long = 2042 Global Const gcxlErrName As Long = 2029 Global Const gcxlErrNull As Long = 2000 Global Const gcxlErrNum As Long = 2036 Global Const gcxlErrRef As Long = 2023 Global Const gcxlErrValue As Long = 2015 'Microsoft Excel Const: XlDataLabelPosition Global Const gcxlLabelPositionAbove As Long = 0 Global Const gcxlLabelPositionBelow As Long = 1 Global Const gcxlLabelPositionBestFit As Long = 5 Global Const gcxlLabelPositionCenter As Long = -4108 Global Const gcxlLabelPositionCustom As Long = 7 Global Const gcxlLabelPositionInsideBase As Long = 4 Global Const gcxlLabelPositionInsideEnd As Long = 3 Global Const gcxlLabelPositionLeft As Long = -4131 Global Const gcxlLabelPositionMixed As Long = 6 Global Const gcxlLabelPositionOutsideEnd As Long = 2 Global Const gcxlLabelPositionRight As Long = -4152 'Microsoft Excel Const: XlDataLabelSeparator Global Const gcxlDataLabelSeparatorDefault As Long = 1 'Microsoft Excel Const: XlDataLabelsType Global Const gcxlDataLabelsShowBubbleSizes As Long = 6 Global Const gcxlDataLabelsShowLabel As Long = 4 Global Const gcxlDataLabelsShowLabelAndPercent As Long = 5 Global Const gcxlDataLabelsShowNone As Long = -4142 Global Const gcxlDataLabelsShowPercent As Long = 3 Global Const gcxlDataLabelsShowValue As Long = 2 'Microsoft Excel Const: XlDataSeriesDate Global Const gcxlDay As Long = 1 Global Const gcxlMonth As Long = 3 Global Const gcxlWeekday As Long = 2 Global Const gcxlYear As Long = 4 'Microsoft Excel Const: XlDataSeriesType Global Const gcxlAutoFill As Long = 4 Global Const gcxlChronological As Long = 3 Global Const gcxlDataSeriesLinear As Long = -4132 Global Const gcxlGrowth As Long = 2 'Microsoft Excel Const: XlDeleteShiftDirection Global Const gcxlShiftToLeft As Long = -4159 Global Const gcxlShiftUp As Long = -4162 'Microsoft Excel Const: XlDirection Global Const gcxlDown As Long = -4121 Global Const gcxlToLeft As Long = -4159 Global Const gcxlToRight As Long = -4161 Global Const gcxlUp As Long = -4162 'Microsoft Excel Const: XlDisplayBlanksAs Global Const gcxlInterpolated As Long = 3 Global Const gcxlNotPlotted As Long = 1 Global Const gcxlZero As Long = 2 'Microsoft Excel Const: XlDisplayDrawingObjects Global Const gcxlDisplayShapes As Long = -4104 Global Const gcxlHide As Long = 3 Global Const gcxlPlaceholders As Long = 2 'Microsoft Excel Const: XlDisplayUnit Global Const gcxlHundredMillions As Long = -8 Global Const gcxlHundreds As Long = -2 Global Const gcxlHundredThousands As Long = -5 Global Const gcxlMillionMillions As Long = -10 Global Const gcxlMillions As Long = -6 Global Const gcxlTenMillions As Long = -7 Global Const gcxlTenThousands As Long = -4 Global Const gcxlThousandMillions As Long = -9 Global Const gcxlThousands As Long = -3 'Microsoft Excel Const: XlDVAlertStyle Global Const gcxlValidAlertInformation As Long = 3 Global Const gcxlValidAlertStop As Long = 1 Global Const gcxlValidAlertWarning As Long = 2 'Microsoft Excel Const: XlDVType Global Const gcxlValidateCustom As Long = 7 Global Const gcxlValidateDate As Long = 4 Global Const gcxlValidateDecimal As Long = 2 Global Const gcxlValidateInputOnly As Long = 0 Global Const gcxlValidateList As Long = 3 Global Const gcxlValidateTextLength As Long = 6 Global Const gcxlValidateTime As Long = 5 Global Const gcxlValidateWholeNumber As Long = 1 'Microsoft Excel Const: XlEditionFormat Global Const gcxlBIFF As Long = 2 Global Const gcxlPICT As Long = 1 Global Const gcxlRTF As Long = 4 Global Const gcxlVALU As Long = 8 'Microsoft Excel Const: XlEditionOptionsOption Global Const gcxlAutomaticUpdate As Long = 4 Global Const gcxlCancel As Long = 1 Global Const gcxlChangeAttributes As Long = 6 Global Const gcxlManualUpdate As Long = 5 Global Const gcxlOpenSource As Long = 3 Global Const gcxlSelect As Long = 3 Global Const gcxlSendPublisher As Long = 2 Global Const gcxlUpdateSubscriber As Long = 2 'Microsoft Excel Const: XlEditionType Global Const gcxlPublisher As Long = 1 Global Const gcxlSubscriber As Long = 2 'Microsoft Excel Const: XlEnableCancelKey Global Const gcxlDisabled As Long = 0 Global Const gcxlErrorHandler As Long = 2 Global Const gcxlInterrupt As Long = 1 'Microsoft Excel Const: XlEnableSelection Global Const gcxlNoRestrictions As Long = 0 Global Const gcxlNoSelection As Long = -4142 Global Const gcxlUnlockedCells As Long = 1 'Microsoft Excel Const: XlEndStyleCap Global Const gcxlCap As Long = 1 Global Const gcxlNoCap As Long = 2 'Microsoft Excel Const: XlErrorBarDirection Global Const gcxlX As Long = -4168 Global Const gcxlY As Long = 1 'Microsoft Excel Const: XlErrorBarInclude Global Const gcxlErrorBarIncludeBoth As Long = 1 Global Const gcxlErrorBarIncludeMinusValues As Long = 3 Global Const gcxlErrorBarIncludeNone As Long = -4142 Global Const gcxlErrorBarIncludePlusValues As Long = 2 'Microsoft Excel Const: XlErrorBarType Global Const gcxlErrorBarTypeCustom As Long = -4114 Global Const gcxlErrorBarTypeFixedValue As Long = 1 Global Const gcxlErrorBarTypePercent As Long = 2 Global Const gcxlErrorBarTypeStDev As Long = -4155 Global Const gcxlErrorBarTypeStError As Long = 4 'Microsoft Excel Const: XlErrorChecks Global Const gcxlEmptyCellReferences As Long = 7 Global Const gcxlEvaluateToError As Long = 1 Global Const gcxlInconsistentFormula As Long = 4 Global Const gcxlListDataValidation As Long = 8 Global Const gcxlNumberAsText As Long = 3 Global Const gcxlOmittedCells As Long = 5 Global Const gcxlTextDate As Long = 2 Global Const gcxlUnlockedFormulaCells As Long = 6 'Microsoft Excel Const: XlFileAccess Global Const gcxlReadOnly As Long = 3 Global Const gcxlReadWrite As Long = 2 'Microsoft Excel Const: XlFileFormat Global Const gcxlAddIn As Long = 18 Global Const gcxlCSV As Long = 6 Global Const gcxlCSVMac As Long = 22 Global Const gcxlCSVMSDOS As Long = 24 Global Const gcxlCSVWindows As Long = 23 Global Const gcxlCurrentPlatformText As Long = -4158 Global Const gcxlDBF2 As Long = 7 Global Const gcxlDBF3 As Long = 8 Global Const gcxlDBF4 As Long = 11 Global Const gcxlDIF As Long = 9 Global Const gcxlExcel2 As Long = 16 Global Const gcxlExcel2FarEast As Long = 27 Global Const gcxlExcel3 As Long = 29 Global Const gcxlExcel4 As Long = 33 Global Const gcxlExcel4Workbook As Long = 35 Global Const gcxlExcel5 As Long = 39 Global Const gcxlExcel7 As Long = 39 Global Const gcxlExcel9795 As Long = 43 Global Const gcxlHtml As Long = 44 Global Const gcxlIntlAddIn As Long = 26 Global Const gcxlIntlMacro As Long = 25 Global Const gcxlSYLK As Long = 2 Global Const gcxlTemplate As Long = 17 Global Const gcxlTextMac As Long = 19 Global Const gcxlTextMSDOS As Long = 21 Global Const gcxlTextPrinter As Long = 36 Global Const gcxlTextWindows As Long = 20 Global Const gcxlUnicodeText As Long = 42 Global Const gcxlWebArchive As Long = 45 Global Const gcxlWJ2WD1 As Long = 14 Global Const gcxlWJ3 As Long = 40 Global Const gcxlWJ3FJ3 As Long = 41 Global Const gcxlWK1 As Long = 5 Global Const gcxlWK1ALL As Long = 31 Global Const gcxlWK1FMT As Long = 30 Global Const gcxlWK3 As Long = 15 Global Const gcxlWK3FM3 As Long = 32 Global Const gcxlWK4 As Long = 38 Global Const gcxlWKS As Long = 4 Global Const gcxlWorkbookNormal As Long = -4143 Global Const gcxlWorks2FarEast As Long = 28 Global Const gcxlWQ1 As Long = 34 Global Const gcxlXMLData As Long = 47 Global Const gcxlXMLSpreadsheet As Long = 46 'Microsoft Excel Const: XlFillWith Global Const gcxlFillWithAll As Long = -4104 Global Const gcxlFillWithContents As Long = 2 Global Const gcxlFillWithFormats As Long = -4122 'Microsoft Excel Const: XlFilterAction Global Const gcxlFilterCopy As Long = 2 Global Const gcxlFilterInPlace As Long = 1 'Microsoft Excel Const: XlFindLookIn Global Const gcxlComments As Long = -4144 Global Const gcxlFormulas As Long = -4123 Global Const gcxlValues As Long = -4163 'Microsoft Excel Const: XlFormatConditionOperator Global Const gcxlBetween As Long = 1 Global Const gcxlEqual As Long = 3 Global Const gcxlGreater As Long = 5 Global Const gcxlGreaterEqual As Long = 7 Global Const gcxlLess As Long = 6 Global Const gcxlLessEqual As Long = 8 Global Const gcxlNotBetween As Long = 2 Global Const gcxlNotEqual As Long = 4 'Microsoft Excel Const: XlFormatConditionType Global Const gcxlCellValue As Long = 1 Global Const gcxlExpression As Long = 2 'Microsoft Excel Const: XlFormControl Global Const gcxlButtonControl As Long = 0 Global Const gcxlCheckBox As Long = 1 Global Const gcxlDropDown As Long = 2 Global Const gcxlEditBox As Long = 3 Global Const gcxlGroupBox As Long = 4 Global Const gcxlLabel As Long = 5 Global Const gcxlListBox As Long = 6 Global Const gcxlOptionButton As Long = 7 Global Const gcxlScrollBar As Long = 8 Global Const gcxlSpinner As Long = 9 'Microsoft Excel Const: XlFormulaLabel Global Const gcxlColumnLabels As Long = 2 Global Const gcxlMixedLabels As Long = 3 Global Const gcxlNoLabels As Long = -4142 Global Const gcxlRowLabels As Long = 1 'Microsoft Excel Const: XlHAlign Global Const gcxlHAlignCenter As Long = -4108 Global Const gcxlHAlignCenterAcrossSelection As Long = 7 Global Const gcxlHAlignDistributed As Long = -4117 Global Const gcxlHAlignFill As Long = 5 Global Const gcxlHAlignGeneral As Long = 1 Global Const gcxlHAlignJustify As Long = -4130 Global Const gcxlHAlignLeft As Long = -4131 Global Const gcxlHAlignRight As Long = -4152 'Microsoft Excel Const: XlHebrewModes Global Const gcxlHebrewFullScript As Long = 0 Global Const gcxlHebrewMixedAuthorizedScript As Long = 3 Global Const gcxlHebrewMixedScript As Long = 2 Global Const gcxlHebrewPartialScript As Long = 1 'Microsoft Excel Const: XlHighlightChangesTime Global Const gcxlAllChanges As Long = 2 Global Const gcxlNotYetReviewed As Long = 3 Global Const gcxlSinceMyLastSave As Long = 1 'Microsoft Excel Const: XlHtmlType Global Const gcxlHtmlCalc As Long = 1 Global Const gcxlHtmlChart As Long = 3 Global Const gcxlHtmlList As Long = 2 Global Const gcxlHtmlStatic As Long = 0 'Microsoft Excel Const: XlIMEMode Global Const gcxlIMEModeAlpha As Long = 8 Global Const gcxlIMEModeAlphaFull As Long = 7 Global Const gcxlIMEModeDisable As Long = 3 Global Const gcxlIMEModeHangul As Long = 10 Global Const gcxlIMEModeHangulFull As Long = 9 Global Const gcxlIMEModeHiragana As Long = 4 Global Const gcxlIMEModeKatakana As Long = 5 Global Const gcxlIMEModeKatakanaHalf As Long = 6 Global Const gcxlIMEModeNoControl As Long = 0 Global Const gcxlIMEModeOff As Long = 2 Global Const gcxlIMEModeOn As Long = 1 'Microsoft Excel Const: XlImportDataAs Global Const gcxlPivotTableReport As Long = 1 Global Const gcxlQueryTable As Long = 0 'Microsoft Excel Const: XlInsertFormatOrigin Global Const gcxlFormatFromLeftOrAbove As Long = 0 Global Const gcxlFormatFromRightOrBelow As Long = 1 'Microsoft Excel Const: XlInsertShiftDirection Global Const gcxlShiftDown As Long = -4121 Global Const gcxlShiftToRight As Long = -4161 'Microsoft Excel Const: XlLayoutFormType Global Const gcxlOutline As Long = 1 Global Const gcxlTabular As Long = 0 'Microsoft Excel Const: XlLegendPosition Global Const gcxlLegendPositionBottom As Long = -4107 Global Const gcxlLegendPositionCorner As Long = 2 Global Const gcxlLegendPositionLeft As Long = -4131 Global Const gcxlLegendPositionRight As Long = -4152 Global Const gcxlLegendPositionTop As Long = -4160 'Microsoft Excel Const: XlLineStyle Global Const gcxlContinuous As Long = 1 Global Const gcxlDash As Long = -4115 Global Const gcxlDashDot As Long = 4 Global Const gcxlDashDotDot As Long = 5 Global Const gcxlDot As Long = -4118 Global Const gcxlDouble As Long = -4119 Global Const gcxlLineStyleNone As Long = -4142 Global Const gcxlSlantDashDot As Long = 13 'Microsoft Excel Const: XlLink Global Const gcxlExcelLinks As Long = 1 Global Const gcxlOLELinks As Long = 2 Global Const gcxlPublishers As Long = 5 Global Const gcxlSubscribers As Long = 6 'Microsoft Excel Const: XlLinkInfo Global Const gcxlEditionDate As Long = 2 Global Const gcxlLinkInfoStatus As Long = 3 Global Const gcxlUpdateState As Long = 1 'Microsoft Excel Const: XlLinkInfoType Global Const gcxlLinkInfoOLELinks As Long = 2 Global Const gcxlLinkInfoPublishers As Long = 5 Global Const gcxlLinkInfoSubscribers As Long = 6 'Microsoft Excel Const: XlLinkStatus Global Const gcxlLinkStatusCopiedValues As Long = 10 Global Const gcxlLinkStatusIndeterminate As Long = 5 Global Const gcxlLinkStatusInvalidName As Long = 7 Global Const gcxlLinkStatusMissingFile As Long = 1 Global Const gcxlLinkStatusMissingSheet As Long = 2 Global Const gcxlLinkStatusNotStarted As Long = 6 Global Const gcxlLinkStatusOK As Long = 0 Global Const gcxlLinkStatusOld As Long = 3 Global Const gcxlLinkStatusSourceNotCalculated As Long = 4 Global Const gcxlLinkStatusSourceNotOpen As Long = 8 Global Const gcxlLinkStatusSourceOpen As Long = 9 'Microsoft Excel Const: XlLinkType Global Const gcxlLinkTypeExcelLinks As Long = 1 Global Const gcxlLinkTypeOLELinks As Long = 2 'Microsoft Excel Const: XlListConflict Global Const gcxlListConflictDialog As Long = 0 Global Const gcxlListConflictDiscardAllConflicts As Long = 2 Global Const gcxlListConflictError As Long = 3 Global Const gcxlListConflictRetryAllConflicts As Long = 1 'Microsoft Excel Const: XlListDataType Global Const gcxlListDataTypeCheckbox As Long = 9 Global Const gcxlListDataTypeChoice As Long = 6 Global Const gcxlListDataTypeChoiceMulti As Long = 7 Global Const gcxlListDataTypeCounter As Long = 11 Global Const gcxlListDataTypeCurrency As Long = 4 Global Const gcxlListDataTypeDateTime As Long = 5 Global Const gcxlListDataTypeHyperLink As Long = 10 Global Const gcxlListDataTypeListLookup As Long = 8 Global Const gcxlListDataTypeMultiLineRichText As Long = 12 Global Const gcxlListDataTypeMultiLineText As Long = 2 Global Const gcxlListDataTypeNone As Long = 0 Global Const gcxlListDataTypeNumber As Long = 3 Global Const gcxlListDataTypeText As Long = 1 'Microsoft Excel Const: XlListObjectSourceType Global Const gcxlSrcExternal As Long = 0 Global Const gcxlSrcRange As Long = 1 Global Const gcxlSrcXml As Long = 2 'Microsoft Excel Const: XlLocationInTable Global Const gcxlColumnHeader As Long = -4110 Global Const gcxlColumnItem As Long = 5 Global Const gcxlDataHeader As Long = 3 Global Const gcxlDataItem As Long = 7 Global Const gcxlPageHeader As Long = 2 Global Const gcxlPageItem As Long = 6 Global Const gcxlRowHeader As Long = -4153 Global Const gcxlRowItem As Long = 4 Global Const gcxlTableBody As Long = 8 'Microsoft Excel Const: XlLookAt Global Const gcxlPart As Long = 2 Global Const gcxlWhole As Long = 1 'Microsoft Excel Const: XlMailSystem Global Const gcxlMAPI As Long = 1 Global Const gcxlNoMailSystem As Long = 0 Global Const gcxlPowerTalk As Long = 2 'Microsoft Excel Const: XlMarkerStyle Global Const gcxlMarkerStyleAutomatic As Long = -4105 Global Const gcxlMarkerStyleCircle As Long = 8 Global Const gcxlMarkerStyleDash As Long = -4115 Global Const gcxlMarkerStyleDiamond As Long = 2 Global Const gcxlMarkerStyleDot As Long = -4118 Global Const gcxlMarkerStyleNone As Long = -4142 Global Const gcxlMarkerStylePicture As Long = -4147 Global Const gcxlMarkerStylePlus As Long = 9 Global Const gcxlMarkerStyleSquare As Long = 1 Global Const gcxlMarkerStyleStar As Long = 5 Global Const gcxlMarkerStyleTriangle As Long = 3 Global Const gcxlMarkerStyleX As Long = -4168 'Microsoft Excel Const: XlMouseButton Global Const gcxlNoButton As Long = 0 Global Const gcxlPrimaryButton As Long = 1 Global Const gcxlSecondaryButton As Long = 2 'Microsoft Excel Const: XlMousePointer Global Const gcxlDefault As Long = -4143 Global Const gcxlIBeam As Long = 3 Global Const gcxlNorthwestArrow As Long = 1 Global Const gcxlWait As Long = 2 'Microsoft Excel Const: XlMSApplication Global Const gcxlMicrosoftAccess As Long = 4 Global Const gcxlMicrosoftFoxPro As Long = 5 Global Const gcxlMicrosoftMail As Long = 3 Global Const gcxlMicrosoftPowerPoint As Long = 2 Global Const gcxlMicrosoftProject As Long = 6 Global Const gcxlMicrosoftSchedulePlus As Long = 7 Global Const gcxlMicrosoftWord As Long = 1 'Microsoft Excel Const: XlObjectSize Global Const gcxlFitToPage As Long = 2 Global Const gcxlFullPage As Long = 3 Global Const gcxlScreenSize As Long = 1 'Microsoft Excel Const: XlOLEType Global Const gcxlOLEControl As Long = 2 Global Const gcxlOLEEmbed As Long = 1 Global Const gcxlOLELink As Long = 0 'Microsoft Excel Const: XlOLEVerb Global Const gcxlVerbOpen As Long = 2 Global Const gcxlVerbPrimary As Long = 1 'Microsoft Excel Const: XlOrder Global Const gcxlDownThenOver As Long = 1 Global Const gcxlOverThenDown As Long = 2 'Microsoft Excel Const: XlOrientation Global Const gcxlDownward As Long = -4170 Global Const gcxlHorizontal As Long = -4128 Global Const gcxlUpward As Long = -4171 Global Const gcxlVertical As Long = -4166 'Microsoft Excel Const: XlPageBreak Global Const gcxlPageBreakAutomatic As Long = -4105 Global Const gcxlPageBreakManual As Long = -4135 Global Const gcxlPageBreakNone As Long = -4142 'Microsoft Excel Const: XlPageBreakExtent Global Const gcxlPageBreakFull As Long = 1 Global Const gcxlPageBreakPartial As Long = 2 'Microsoft Excel Const: XlPageOrientation Global Const gcxlLandscape As Long = 2 Global Const gcxlPortrait As Long = 1 'Microsoft Excel Const: XlPaperSize Global Const gcxlPaper10x14 As Long = 16 Global Const gcxlPaper11x17 As Long = 17 Global Const gcxlPaperA3 As Long = 8 Global Const gcxlPaperA4 As Long = 9 Global Const gcxlPaperA4Small As Long = 10 Global Const gcxlPaperA5 As Long = 11 Global Const gcxlPaperB4 As Long = 12 Global Const gcxlPaperB5 As Long = 13 Global Const gcxlPaperCsheet As Long = 24 Global Const gcxlPaperDsheet As Long = 25 Global Const gcxlPaperEnvelope10 As Long = 20 Global Const gcxlPaperEnvelope11 As Long = 21 Global Const gcxlPaperEnvelope12 As Long = 22 Global Const gcxlPaperEnvelope14 As Long = 23 Global Const gcxlPaperEnvelope9 As Long = 19 Global Const gcxlPaperEnvelopeB4 As Long = 33 Global Const gcxlPaperEnvelopeB5 As Long = 34 Global Const gcxlPaperEnvelopeB6 As Long = 35 Global Const gcxlPaperEnvelopeC3 As Long = 29 Global Const gcxlPaperEnvelopeC4 As Long = 30 Global Const gcxlPaperEnvelopeC5 As Long = 28 Global Const gcxlPaperEnvelopeC6 As Long = 31 Global Const gcxlPaperEnvelopeC65 As Long = 32 Global Const gcxlPaperEnvelopeDL As Long = 27 Global Const gcxlPaperEnvelopeItaly As Long = 36 Global Const gcxlPaperEnvelopeMonarch As Long = 37 Global Const gcxlPaperEnvelopePersonal As Long = 38 Global Const gcxlPaperEsheet As Long = 26 Global Const gcxlPaperExecutive As Long = 7 Global Const gcxlPaperFanfoldLegalGerman As Long = 41 Global Const gcxlPaperFanfoldStdGerman As Long = 40 Global Const gcxlPaperFanfoldUS As Long = 39 Global Const gcxlPaperFolio As Long = 14 Global Const gcxlPaperLedger As Long = 4 Global Const gcxlPaperLegal As Long = 5 Global Const gcxlPaperLetter As Long = 1 Global Const gcxlPaperLetterSmall As Long = 2 Global Const gcxlPaperNote As Long = 18 Global Const gcxlPaperQuarto As Long = 15 Global Const gcxlPaperStatement As Long = 6 Global Const gcxlPaperTabloid As Long = 3 Global Const gcxlPaperUser As Long = 256 'Microsoft Excel Const: XlParameterDataType Global Const gcxlParamTypeBigInt As Long = -5 Global Const gcxlParamTypeBinary As Long = -2 Global Const gcxlParamTypeBit As Long = -7 Global Const gcxlParamTypeChar As Long = 1 Global Const gcxlParamTypeDate As Long = 9 Global Const gcxlParamTypeDecimal As Long = 3 Global Const gcxlParamTypeDouble As Long = 8 Global Const gcxlParamTypeFloat As Long = 6 Global Const gcxlParamTypeInteger As Long = 4 Global Const gcxlParamTypeLongVarBinary As Long = -4 Global Const gcxlParamTypeLongVarChar As Long = -1 Global Const gcxlParamTypeNumeric As Long = 2 Global Const gcxlParamTypeReal As Long = 7 Global Const gcxlParamTypeSmallInt As Long = 5 Global Const gcxlParamTypeTime As Long = 10 Global Const gcxlParamTypeTimestamp As Long = 11 Global Const gcxlParamTypeTinyInt As Long = -6 Global Const gcxlParamTypeUnknown As Long = 0 Global Const gcxlParamTypeVarBinary As Long = -3 Global Const gcxlParamTypeVarChar As Long = 12 Global Const gcxlParamTypeWChar As Long = -8 'Microsoft Excel Const: XlParameterType Global Const gcxlConst As Long = 1 Global Const gcxlPrompt As Long = 0 Global Const gcxlRange As Long = 2 'Microsoft Excel Const: XlPasteSpecialOperation Global Const gcxlPasteSpecialOperationAdd As Long = 2 Global Const gcxlPasteSpecialOperationDivide As Long = 5 Global Const gcxlPasteSpecialOperationMultiply As Long = 4 Global Const gcxlPasteSpecialOperationNone As Long = -4142 Global Const gcxlPasteSpecialOperationSubtract As Long = 3 'Microsoft Excel Const: XlPasteType Global Const gcxlPasteAll As Long = -4104 Global Const gcxlPasteAllExceptBorders As Long = 7 Global Const gcxlPasteColumnWidths As Long = 8 Global Const gcxlPasteComments As Long = -4144 Global Const gcxlPasteFormats As Long = -4122 Global Const gcxlPasteFormulas As Long = -4123 Global Const gcxlPasteFormulasAndNumberFormats As Long = 11 Global Const gcxlPasteValidation As Long = 6 Global Const gcxlPasteValues As Long = -4163 Global Const gcxlPasteValuesAndNumberFormats As Long = 12 'Microsoft Excel Const: XlPattern Global Const gcxlPatternAutomatic As Long = -4105 Global Const gcxlPatternChecker As Long = 9 Global Const gcxlPatternCrissCross As Long = 16 Global Const gcxlPatternDown As Long = -4121 Global Const gcxlPatternGray16 As Long = 17 Global Const gcxlPatternGray25 As Long = -4124 Global Const gcxlPatternGray50 As Long = -4125 Global Const gcxlPatternGray75 As Long = -4126 Global Const gcxlPatternGray8 As Long = 18 Global Const gcxlPatternGrid As Long = 15 Global Const gcxlPatternHorizontal As Long = -4128 Global Const gcxlPatternLightDown As Long = 13 Global Const gcxlPatternLightHorizontal As Long = 11 Global Const gcxlPatternLightUp As Long = 14 Global Const gcxlPatternLightVertical As Long = 12 Global Const gcxlPatternNone As Long = -4142 Global Const gcxlPatternSemiGray75 As Long = 10 Global Const gcxlPatternSolid As Long = 1 Global Const gcxlPatternUp As Long = -4162 Global Const gcxlPatternVertical As Long = -4166 'Microsoft Excel Const: XlPhoneticAlignment Global Const gcxlPhoneticAlignCenter As Long = 2 Global Const gcxlPhoneticAlignDistributed As Long = 3 Global Const gcxlPhoneticAlignLeft As Long = 1 Global Const gcxlPhoneticAlignNoControl As Long = 0 'Microsoft Excel Const: XlPhoneticCharacterType Global Const gcxlHiragana As Long = 2 Global Const gcxlKatakana As Long = 1 Global Const gcxlKatakanaHalf As Long = 0 Global Const gcxlNoConversion As Long = 3 'Microsoft Excel Const: XlPictureAppearance Global Const gcxlPrinter As Long = 2 Global Const gcxlScreen As Long = 1 'Microsoft Excel Const: XlPictureConvertorType Global Const gcxlBMP As Long = 1 Global Const gcxlCGM As Long = 7 Global Const gcxlDRW As Long = 4 Global Const gcxlDXF As Long = 5 Global Const gcxlEPS As Long = 8 Global Const gcxlHGL As Long = 6 Global Const gcxlPCT As Long = 13 Global Const gcxlPCX As Long = 10 Global Const gcxlPIC As Long = 11 Global Const gcxlPLT As Long = 12 Global Const gcxlTIF As Long = 9 Global Const gcxlWMF As Long = 2 Global Const gcxlWPG As Long = 3 'Microsoft Excel Const: XlPivotCellType Global Const gcxlPivotCellBlankCell As Long = 9 Global Const gcxlPivotCellCustomSubtotal As Long = 7 Global Const gcxlPivotCellDataField As Long = 4 Global Const gcxlPivotCellDataPivotField As Long = 8 Global Const gcxlPivotCellGrandTotal As Long = 3 Global Const gcxlPivotCellPageFieldItem As Long = 6 Global Const gcxlPivotCellPivotField As Long = 5 Global Const gcxlPivotCellPivotItem As Long = 1 Global Const gcxlPivotCellSubtotal As Long = 2 Global Const gcxlPivotCellValue As Long = 0 'Microsoft Excel Const: XlPivotFieldCalculation Global Const gcxlDifferenceFrom As Long = 2 Global Const gcxlIndex As Long = 9 Global Const gcxlNoAdditionalCalculation As Long = -4143 Global Const gcxlPercentDifferenceFrom As Long = 4 Global Const gcxlPercentOf As Long = 3 Global Const gcxlPercentOfColumn As Long = 7 Global Const gcxlPercentOfRow As Long = 6 Global Const gcxlPercentOfTotal As Long = 8 Global Const gcxlRunningTotal As Long = 5 'Microsoft Excel Const: XlPivotFieldDataType Global Const gcxlDate As Long = 2 Global Const gcxlNumber As Long = -4145 Global Const gcxlText As Long = -4158 'Microsoft Excel Const: XlPivotFieldOrientation Global Const gcxlColumnField As Long = 2 Global Const gcxlDataField As Long = 4 Global Const gcxlHidden As Long = 0 Global Const gcxlPageField As Long = 3 Global Const gcxlRowField As Long = 1 'Microsoft Excel Const: XlPivotFormatType Global Const gcxlPTClassic As Long = 20 Global Const gcxlPTNone As Long = 21 Global Const gcxlReport1 As Long = 0 Global Const gcxlReport10 As Long = 9 Global Const gcxlReport2 As Long = 1 Global Const gcxlReport3 As Long = 2 Global Const gcxlReport4 As Long = 3 Global Const gcxlReport5 As Long = 4 Global Const gcxlReport6 As Long = 5 Global Const gcxlReport7 As Long = 6 Global Const gcxlReport8 As Long = 7 Global Const gcxlReport9 As Long = 8 Global Const gcxlTable1 As Long = 10 Global Const gcxlTable10 As Long = 19 Global Const gcxlTable2 As Long = 11 Global Const gcxlTable3 As Long = 12 Global Const gcxlTable4 As Long = 13 Global Const gcxlTable5 As Long = 14 Global Const gcxlTable6 As Long = 15 Global Const gcxlTable7 As Long = 16 Global Const gcxlTable8 As Long = 17 Global Const gcxlTable9 As Long = 18 'Microsoft Excel Const: XlPivotTableMissingItems Global Const gcxlMissingItemsDefault As Long = -1 Global Const gcxlMissingItemsMax As Long = 32500 Global Const gcxlMissingItemsNone As Long = 0 'Microsoft Excel Const: XlPivotTableSourceType Global Const gcxlConsolidation As Long = 3 Global Const gcxlDatabase As Long = 1 Global Const gcxlExternal As Long = 2 Global Const gcxlPivotTable As Long = -4148 Global Const gcxlScenario As Long = 4 'Microsoft Excel Const: XlPivotTableVersionList Global Const gcxlPivotTableVersion10 As Long = 1 Global Const gcxlPivotTableVersion2000 As Long = 0 Global Const gcxlPivotTableVersionCurrent As Long = -1 'Microsoft Excel Const: XlPlacement Global Const gcxlFreeFloating As Long = 3 Global Const gcxlMove As Long = 2 Global Const gcxlMoveAndSize As Long = 1 'Microsoft Excel Const: XlPlatform Global Const gcxlMacintosh As Long = 1 Global Const gcxlMSDOS As Long = 3 Global Const gcxlWindows As Long = 2 'Microsoft Excel Const: XlPrintErrors Global Const gcxlPrintErrorsBlank As Long = 1 Global Const gcxlPrintErrorsDash As Long = 2 Global Const gcxlPrintErrorsDisplayed As Long = 0 Global Const gcxlPrintErrorsNA As Long = 3 'Microsoft Excel Const: XlPrintLocation Global Const gcxlPrintInPlace As Long = 16 Global Const gcxlPrintNoComments As Long = -4142 Global Const gcxlPrintSheetEnd As Long = 1 'Microsoft Excel Const: XlPriority Global Const gcxlPriorityHigh As Long = -4127 Global Const gcxlPriorityLow As Long = -4134 Global Const gcxlPriorityNormal As Long = -4143 'Microsoft Excel Const: XlPTSelectionMode Global Const gcxlBlanks As Long = 4 Global Const gcxlButton As Long = 15 Global Const gcxlDataAndLabel As Long = 0 Global Const gcxlDataOnly As Long = 2 Global Const gcxlFirstRow As Long = 256 Global Const gcxlLabelOnly As Long = 1 Global Const gcxlOrigin As Long = 3 'Microsoft Excel Const: XlQueryType Global Const gcxlADORecordset As Long = 7 Global Const gcxlDAORecordset As Long = 2 Global Const gcxlODBCQuery As Long = 1 Global Const gcxlOLEDBQuery As Long = 5 Global Const gcxlTextImport As Long = 6 Global Const gcxlWebQuery As Long = 4 'Microsoft Excel Const: XlRangeAutoFormat Global Const gcxlRangeAutoFormat3DEffects1 As Long = 13 Global Const gcxlRangeAutoFormat3DEffects2 As Long = 14 Global Const gcxlRangeAutoFormatAccounting1 As Long = 4 Global Const gcxlRangeAutoFormatAccounting2 As Long = 5 Global Const gcxlRangeAutoFormatAccounting3 As Long = 6 Global Const gcxlRangeAutoFormatAccounting4 As Long = 17 Global Const gcxlRangeAutoFormatClassic1 As Long = 1 Global Const gcxlRangeAutoFormatClassic2 As Long = 2 Global Const gcxlRangeAutoFormatClassic3 As Long = 3 Global Const gcxlRangeAutoFormatClassicPivotTable As Long = 31 Global Const gcxlRangeAutoFormatColor1 As Long = 7 Global Const gcxlRangeAutoFormatColor2 As Long = 8 Global Const gcxlRangeAutoFormatColor3 As Long = 9 Global Const gcxlRangeAutoFormatList1 As Long = 10 Global Const gcxlRangeAutoFormatList2 As Long = 11 Global Const gcxlRangeAutoFormatList3 As Long = 12 Global Const gcxlRangeAutoFormatLocalFormat1 As Long = 15 Global Const gcxlRangeAutoFormatLocalFormat2 As Long = 16 Global Const gcxlRangeAutoFormatLocalFormat3 As Long = 19 Global Const gcxlRangeAutoFormatLocalFormat4 As Long = 20 Global Const gcxlRangeAutoFormatNone As Long = -4142 Global Const gcxlRangeAutoFormatPTNone As Long = 42 Global Const gcxlRangeAutoFormatReport1 As Long = 21 Global Const gcxlRangeAutoFormatReport10 As Long = 30 Global Const gcxlRangeAutoFormatReport2 As Long = 22 Global Const gcxlRangeAutoFormatReport3 As Long = 23 Global Const gcxlRangeAutoFormatReport4 As Long = 24 Global Const gcxlRangeAutoFormatReport5 As Long = 25 Global Const gcxlRangeAutoFormatReport6 As Long = 26 Global Const gcxlRangeAutoFormatReport7 As Long = 27 Global Const gcxlRangeAutoFormatReport8 As Long = 28 Global Const gcxlRangeAutoFormatReport9 As Long = 29 Global Const gcxlRangeAutoFormatSimple As Long = -4154 Global Const gcxlRangeAutoFormatTable1 As Long = 32 Global Const gcxlRangeAutoFormatTable10 As Long = 41 Global Const gcxlRangeAutoFormatTable2 As Long = 33 Global Const gcxlRangeAutoFormatTable3 As Long = 34 Global Const gcxlRangeAutoFormatTable4 As Long = 35 Global Const gcxlRangeAutoFormatTable5 As Long = 36 Global Const gcxlRangeAutoFormatTable6 As Long = 37 Global Const gcxlRangeAutoFormatTable7 As Long = 38 Global Const gcxlRangeAutoFormatTable8 As Long = 39 Global Const gcxlRangeAutoFormatTable9 As Long = 40 'Microsoft Excel Const: XlRangeValueDataType Global Const gcxlRangeValueDefault As Long = 10 Global Const gcxlRangeValueMSPersistXML As Long = 12 Global Const gcxlRangeValueXMLSpreadsheet As Long = 11 'Microsoft Excel Const: XlReferenceStyle Global Const gcxlA1 As Long = 1 Global Const gcxlR1C1 As Long = -4150 'Microsoft Excel Const: XlReferenceType Global Const gcxlAbsolute As Long = 1 Global Const gcxlAbsRowRelColumn As Long = 2 Global Const gcxlRelative As Long = 4 Global Const gcxlRelRowAbsColumn As Long = 3 'Microsoft Excel Const: XlRobustConnect Global Const gcxlAlways As Long = 1 Global Const gcxlAsRequired As Long = 0 Global Const gcxlNever As Long = 2 'Microsoft Excel Const: XlRoutingSlipDelivery Global Const gcxlAllAtOnce As Long = 2 Global Const gcxlOneAfterAnother As Long = 1 'Microsoft Excel Const: XlRoutingSlipStatus Global Const gcxlNotYetRouted As Long = 0 Global Const gcxlRoutingComplete As Long = 2 Global Const gcxlRoutingInProgress As Long = 1 'Microsoft Excel Const: XlRowCol Global Const gcxlColumns As Long = 2 Global Const gcxlRows As Long = 1 'Microsoft Excel Const: XlRunAutoMacro Global Const gcxlAutoActivate As Long = 3 Global Const gcxlAutoClose As Long = 2 Global Const gcxlAutoDeactivate As Long = 4 Global Const gcxlAutoOpen As Long = 1 'Microsoft Excel Const: XlSaveAction Global Const gcxlDoNotSaveChanges As Long = 2 Global Const gcxlSaveChanges As Long = 1 'Microsoft Excel Const: XlSaveAsAccessMode Global Const gcxlExclusive As Long = 3 Global Const gcxlNoChange As Long = 1 Global Const gcxlShared As Long = 2 'Microsoft Excel Const: XlSaveConflictResolution Global Const gcxlLocalSessionChanges As Long = 2 Global Const gcxlOtherSessionChanges As Long = 3 Global Const gcxlUserResolution As Long = 1 'Microsoft Excel Const: XlScaleType Global Const gcxlScaleLinear As Long = -4132 Global Const gcxlScaleLogarithmic As Long = -4133 'Microsoft Excel Const: XlSearchDirection Global Const gcxlNext As Long = 1 Global Const gcxlPrevious As Long = 2 'Microsoft Excel Const: XlSearchOrder Global Const gcxlByColumns As Long = 2 Global Const gcxlByRows As Long = 1 'Microsoft Excel Const: XlSearchWithin Global Const gcxlWithinSheet As Long = 1 Global Const gcxlWithinWorkbook As Long = 2 'Microsoft Excel Const: XlSheetType Global Const gcxlChart As Long = -4109 Global Const gcxlDialogSheet As Long = -4116 Global Const gcxlExcel4IntlMacroSheet As Long = 4 Global Const gcxlExcel4MacroSheet As Long = 3 Global Const gcxlWorksheet As Long = -4167 'Microsoft Excel Const: XlSheetVisibility Global Const gcxlSheetHidden As Long = 0 Global Const gcxlSheetVeryHidden As Long = 2 Global Const gcxlSheetVisible As Long = -1 'Microsoft Excel Const: XlSizeRepresents Global Const gcxlSizeIsArea As Long = 1 Global Const gcxlSizeIsWidth As Long = 2 'Microsoft Excel Const: XlSmartTagControlType Global Const gcxlSmartTagControlActiveX As Long = 13 Global Const gcxlSmartTagControlButton As Long = 6 Global Const gcxlSmartTagControlCheckbox As Long = 9 Global Const gcxlSmartTagControlCombo As Long = 12 Global Const gcxlSmartTagControlHelp As Long = 3 Global Const gcxlSmartTagControlHelpURL As Long = 4 Global Const gcxlSmartTagControlImage As Long = 8 Global Const gcxlSmartTagControlLabel As Long = 7 Global Const gcxlSmartTagControlLink As Long = 2 Global Const gcxlSmartTagControlListbox As Long = 11 Global Const gcxlSmartTagControlRadioGroup As Long = 14 Global Const gcxlSmartTagControlSeparator As Long = 5 Global Const gcxlSmartTagControlSmartTag As Long = 1 Global Const gcxlSmartTagControlTextbox As Long = 10 'Microsoft Excel Const: XlSmartTagDisplayMode Global Const gcxlButtonOnly As Long = 2 Global Const gcxlDisplayNone As Long = 1 Global Const gcxlIndicatorAndButton As Long = 0 'Microsoft Excel Const: XlSortDataOption Global Const gcxlSortNormal As Long = 0 Global Const gcxlSortTextAsNumbers As Long = 1 'Microsoft Excel Const: XlSortMethod Global Const gcxlPinYin As Long = 1 Global Const gcxlStroke As Long = 2 'Microsoft Excel Const: XlSortMethodOld Global Const gcxlCodePage As Long = 2 Global Const gcxlSyllabary As Long = 1 'Microsoft Excel Const: XlSortOrder Global Const gcxlAscending As Long = 1 Global Const gcxlDescending As Long = 2 'Microsoft Excel Const: XlSortOrientation Global Const gcxlSortColumns As Long = 1 Global Const gcxlSortRows As Long = 2 'Microsoft Excel Const: XlSortType Global Const gcxlSortLabels As Long = 2 Global Const gcxlSortValues As Long = 1 'Microsoft Excel Const: XlSourceType Global Const gcxlSourceAutoFilter As Long = 3 Global Const gcxlSourceChart As Long = 5 Global Const gcxlSourcePivotTable As Long = 6 Global Const gcxlSourcePrintArea As Long = 2 Global Const gcxlSourceQuery As Long = 7 Global Const gcxlSourceRange As Long = 4 Global Const gcxlSourceSheet As Long = 1 Global Const gcxlSourceWorkbook As Long = 0 'Microsoft Excel Const: XlSpeakDirection Global Const gcxlSpeakByColumns As Long = 1 Global Const gcxlSpeakByRows As Long = 0 'Microsoft Excel Const: XlSpecialCellsValue Global Const gcxlErrors As Long = 16 Global Const gcxlLogical As Long = 4 Global Const gcxlNumbers As Long = 1 Global Const gcxlTextValues As Long = 2 'Microsoft Excel Const: XlSubscribeToFormat Global Const gcxlSubscribeToPicture As Long = -4147 Global Const gcxlSubscribeToText As Long = -4158 'Microsoft Excel Const: XlSubtototalLocationType Global Const gcxlAtBottom As Long = 2 Global Const gcxlAtTop As Long = 1 'Microsoft Excel Const: XlSummaryColumn Global Const gcxlSummaryOnLeft As Long = -4131 Global Const gcxlSummaryOnRight As Long = -4152 'Microsoft Excel Const: XlSummaryReportType Global Const gcxlStandardSummary As Long = 1 Global Const gcxlSummaryPivotTable As Long = -4148 'Microsoft Excel Const: XlSummaryRow Global Const gcxlSummaryAbove As Long = 0 Global Const gcxlSummaryBelow As Long = 1 'Microsoft Excel Const: XlTabPosition Global Const gcxlTabPositionFirst As Long = 0 Global Const gcxlTabPositionLast As Long = 1 'Microsoft Excel Const: XlTextParsingType Global Const gcxlDelimited As Long = 1 Global Const gcxlFixedWidth As Long = 2 'Microsoft Excel Const: XlTextQualifier Global Const gcxlTextQualifierDoubleQuote As Long = 1 Global Const gcxlTextQualifierNone As Long = -4142 Global Const gcxlTextQualifierSingleQuote As Long = 2 'Microsoft Excel Const: XlTextVisualLayoutType Global Const gcxlTextVisualLTR As Long = 1 Global Const gcxlTextVisualRTL As Long = 2 'Microsoft Excel Const: XlTickLabelOrientation Global Const gcxlTickLabelOrientationAutomatic As Long = -4105 Global Const gcxlTickLabelOrientationDownward As Long = -4170 Global Const gcxlTickLabelOrientationHorizontal As Long = -4128 Global Const gcxlTickLabelOrientationUpward As Long = -4171 Global Const gcxlTickLabelOrientationVertical As Long = -4166 'Microsoft Excel Const: XlTickLabelPosition Global Const gcxlTickLabelPositionHigh As Long = -4127 Global Const gcxlTickLabelPositionLow As Long = -4134 Global Const gcxlTickLabelPositionNextToAxis As Long = 4 Global Const gcxlTickLabelPositionNone As Long = -4142 'Microsoft Excel Const: XlTickMark Global Const gcxlTickMarkCross As Long = 4 Global Const gcxlTickMarkInside As Long = 2 Global Const gcxlTickMarkNone As Long = -4142 Global Const gcxlTickMarkOutside As Long = 3 'Microsoft Excel Const: XlTimeUnit Global Const gcxlDays As Long = 0 Global Const gcxlMonths As Long = 1 Global Const gcxlYears As Long = 2 'Microsoft Excel Const: XlToolbarProtection Global Const gcxlNoButtonChanges As Long = 1 Global Const gcxlNoChanges As Long = 4 Global Const gcxlNoDockingChanges As Long = 3 Global Const gcxlNoShapeChanges As Long = 2 Global Const gcxlToolbarProtectionNone As Long = -4143 'Microsoft Excel Const: XlTotalsCalculation Global Const gcxlTotalsCalculationAverage As Long = 2 Global Const gcxlTotalsCalculationCount As Long = 3 Global Const gcxlTotalsCalculationCountNums As Long = 4 Global Const gcxlTotalsCalculationMax As Long = 6 Global Const gcxlTotalsCalculationMin As Long = 5 Global Const gcxlTotalsCalculationNone As Long = 0 Global Const gcxlTotalsCalculationStdDev As Long = 7 Global Const gcxlTotalsCalculationSum As Long = 1 Global Const gcxlTotalsCalculationVar As Long = 8 'Microsoft Excel Const: XlTrendlineType Global Const gcxlExponential As Long = 5 Global Const gcxlLinear As Long = -4132 Global Const gcxlLogarithmic As Long = -4133 Global Const gcxlMovingAvg As Long = 6 Global Const gcxlPolynomial As Long = 3 Global Const gcxlPower As Long = 4 'Microsoft Excel Const: XlUnderlineStyle Global Const gcxlUnderlineStyleDouble As Long = -4119 Global Const gcxlUnderlineStyleDoubleAccounting As Long = 5 Global Const gcxlUnderlineStyleNone As Long = -4142 Global Const gcxlUnderlineStyleSingle As Long = 2 Global Const gcxlUnderlineStyleSingleAccounting As Long = 4 'Microsoft Excel Const: XlUpdateLinks Global Const gcxlUpdateLinksAlways As Long = 3 Global Const gcxlUpdateLinksNever As Long = 2 Global Const gcxlUpdateLinksUserSetting As Long = 1 'Microsoft Excel Const: XlVAlign Global Const gcxlVAlignBottom As Long = -4107 Global Const gcxlVAlignCenter As Long = -4108 Global Const gcxlVAlignDistributed As Long = -4117 Global Const gcxlVAlignJustify As Long = -4130 Global Const gcxlVAlignTop As Long = -4160 'Microsoft Excel Const: XlWBATemplate Global Const gcxlWBATChart As Long = -4109 Global Const gcxlWBATExcel4IntlMacroSheet As Long = 4 Global Const gcxlWBATExcel4MacroSheet As Long = 3 Global Const gcxlWBATWorksheet As Long = -4167 'Microsoft Excel Const: XlWebFormatting Global Const gcxlWebFormattingAll As Long = 1 Global Const gcxlWebFormattingNone As Long = 3 Global Const gcxlWebFormattingRTF As Long = 2 'Microsoft Excel Const: XlWebSelectionType Global Const gcxlAllTables As Long = 2 Global Const gcxlEntirePage As Long = 1 Global Const gcxlSpecifiedTables As Long = 3 'Microsoft Excel Const: XlWindowState Global Const gcxlMaximized As Long = -4137 Global Const gcxlMinimized As Long = -4140 Global Const gcxlNormal As Long = -4143 'Microsoft Excel Const: XlWindowType Global Const gcxlChartAsWindow As Long = 5 Global Const gcxlChartInPlace As Long = 4 Global Const gcxlClipboard As Long = 3 Global Const gcxlInfo As Long = -4129 Global Const gcxlWorkbook As Long = 1 'Microsoft Excel Const: XlWindowView Global Const gcxlNormalView As Long = 1 Global Const gcxlPageBreakPreview As Long = 2 'Microsoft Excel Const: XlXLMMacroType Global Const gcxlCommand As Long = 2 Global Const gcxlFunction As Long = 1 Global Const gcxlNotXLM As Long = 3 'Microsoft Excel Const: XlXmlExportResult Global Const gcxlXmlExportSuccess As Long = 0 Global Const gcxlXmlExportValidationFailed As Long = 1 'Microsoft Excel Const: XlXmlImportResult Global Const gcxlXmlImportElementsTruncated As Long = 1 Global Const gcxlXmlImportSuccess As Long = 0 Global Const gcxlXmlImportValidationFailed As Long = 2 'Microsoft Excel Const: XlXmlLoadOption Global Const gcxlXmlLoadImportToList As Long = 2 Global Const gcxlXmlLoadMapXml As Long = 3 Global Const gcxlXmlLoadOpenXml As Long = 1 Global Const gcxlXmlLoadPromptUser As Long = 0 'Microsoft Excel Const: XlYesNoGuess Global Const gcxlGuess As Long = 0 Global Const gcxlNo As Long = 2 Global Const gcxlYes As Long = 1