cmd看excel有多少个子表_Excel常用枚举常量列表，对应的数字终于全成查了

xlUnlockedFormulaCells&lt

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:57:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlFileAccess

Constant

Value

xlReadOnly

3

xlReadWrite

2

XlFileFormat

Constant

Value

xlAddIn

18

xlCSV

6

xlCSVMac

22

xlCSVMSDOS

24

xlCSVWindows

23

xlCurrentPlatformText

-4158

xlDBF2

7

xlDBF3

8

xlDBF4

11

xlDIF

9

xlExcel2

16

xlExcel2FarEast

27

xlExcel3

29

xlExcel4

33

xlExcel4Workbook

35

xlExcel5

39

xlExcel7

39

xlExcel9795

43

xlHtml

44

xlIntlAddIn

26

xlIntlMacro

25

xlSYLK

2

xlTemplate

17

xlTextMac

19

xlTextMSDOS

21

xlTextPrinter

36

xlTextWindows

20

xlUnicodeText

42

xlWebArchive

45

xlWJ2WD1

14

xlWJ3

40

xlWJ3FJ3

41

xlWK1

5

xlWK1ALL

31

xlWK1FMT

30

xlWK3

15

xlWK3FM3

32

xlWK4

38

xlWKS

4

xlWorkbookNormal

-4143

xlWorks2FarEast

28

xlWQ1

34

xlXMLData

47

xlXMLSpreadsheet

46

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlFillWith

Constant

Value

xlFillWithAll

-4104

xlFillWithContents

2

xlFillWithFormats

-4122

XlFilterAction

Constant

Value

xlFilterCopy

2

xlFilterInPlace

1

XlFindLookIn

Constant

Value

xlComments

-4144

xlFormulas

-4123

xlValues

-4163

XlFormatConditionOperator

Constant

Value

xlBetween

1

xlEqual

3

xlGreater

5

xlGreaterEqual

7

xlLess

6

xlLessEqual

8

xlNotBetween

2

xlNotEqual

4

XlFormatConditionType

Constant

Value

xlCellValue

1

xlExpression

2

XlFormControl

Constant

Value

xlButtonControl

0

xlCheckBox

1

xlDropDown

2

xlEditBox

3

xlGroupBox

4

xlLabel

5

xlListBox

6

xlOptionButton

7

xlScrollBar

8

xlSpinner

9

XlFormulaLabel

Constant

Value

xlColumnLabels

2

xlMixedLabels

3

xlNoLabels

-4142

xlRowLabels

1

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlHAlign

Constant

Value

xlHAlignCenter

-4108

xlHAlignCenterAcrossSelection

7

xlHAlignDistributed

-4117

xlHAlignFill

5

xlHAlignGeneral

1

xlHAlignJustify

-4130

xlHAlignLeft

-4131

xlHAlignRight

-4152

XlHebrewModes

Constant

Value

xlHebrewFullScript

0

xlHebrewMixedAuthorizedScript

3

xlHebrewMixedScript

2

xlHebrewPartialScript

1

XlHighlightChangesTime

Constant

Value

xlAllChanges

2

xlNotYetReviewed

3

xlSinceMyLastSave

1

XlHtmlType

Constant

Value

xlHtmlCalc

1

xlHtmlChart

3

xlHtmlList

2

xlHtmlStatic

0

XlIMEMode

Constant

Value

xlIMEModeAlpha

8

xlIMEModeAlphaFull

7

xlIMEModeDisable

3

xlIMEModeHangul

10

xlIMEModeHangulFull

9

xlIMEModeHiragana

4

xlIMEModeKatakana

5

xlIMEModeKatakanaHalf

6

xlIMEModeNoControl

0

xlIMEModeOff

2

xlIMEModeOn

1

XlImportDataAs

Constant

Value

xlPivotTableReport

1

xlQueryTable

0

XlInsertFormatOrigin

Constant

Value

xlFormatFromLeftOrAbove

0

xlFormatFromRightOrBelow

1

XlInsertShiftDirection

Constant

Value

xlShiftDown

-4121

xlShiftToRight

-4161

XlLayoutFormType

Constant

Value

xlOutline

1

xlTabular

0

XlLegendPosition

Constant

Value

xlLegendPositionBottom

-4107

xlLegendPositionCorner

2

xlLegendPositionLeft

-4131

xlLegendPositionRight

-4152

xlLegendPositionTop

-4160

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlLineStyle

Constant

Value

xlContinuous

1

xlDash

-4115

xlDashDot

4

xlDashDotDot

5

xlDot

-4118

xlDouble

-4119

xlLineStyleNone

-4142

xlSlantDashDot

13

XlLink

Constant

Value

xlExcelLinks

1

xlOLELinks

2

xlPublishers

5

xlSubscribers

6

XlLinkInfo

Constant

Value

xlEditionDate

2

xlLinkInfoStatus

3

xlUpdateState

1

XlLinkInfoType

Constant

Value

xlLinkInfoOLELinks

2

xlLinkInfoPublishers

5

xlLinkInfoSubscribers

6

XlLinkStatus

Constant

Value

xlLinkStatusCopiedValues

10

xlLinkStatusIndeterminate

5

xlLinkStatusInvalidName

7

xlLinkStatusMissingFile

1

xlLinkStatusMissingSheet

2

xlLinkStatusNotStarted

6

xlLinkStatusOK

0

xlLinkStatusOld

3

xlLinkStatusSourceNotCalculated

4

xlLinkStatusSourceNotOpen

8

xlLinkStatusSourceOpen

9

XlLinkType

Constant

Value

xlLinkTypeExcelLinks

1

xlLinkTypeOLELinks

2

XlListConflict

Constant

Value

xlListConflictDialog

0

xlListConflictDiscardAllConflicts

2

xlListConflictError

3

xlListConflictRetryAllConflicts

1

XlListDataType

Constant

Value

xlListDataTypeCheckbox

9

xlListDataTypeChoice

6

xlListDataTypeChoiceMulti

7

xlListDataTypeCounter

11

xlListDataTypeCurrency

4

xlListDataTypeDateTime

5

xlListDataTypeHyperLink

10

xlListDataTypeListLookup

8

xlListDataTypeMultiLineRichText

12

xlListDataTypeMultiLineText

2

xlListDataTypeNone

0

xlListDataTypeNumber

3

xlListDataTypeText

1

XlListObjectSourceType

Constant

Value

xlSrcExternal

0

xlSrcRange

1

xlSrcXml

2

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlLocationInTable

Constant

Value

xlColumnHeader

-4110

xlColumnItem

5

xlDataHeader

3

xlDataItem

7

xlPageHeader

2

xlPageItem

6

xlRowHeader

-4153

xlRowItem

4

xlTableBody

8

XlLookAt

Constant

Value

xlPart

2

xlWhole

1

XlMailSystem

Constant

Value

xlMAPI

1

xlNoMailSystem

0

xlPowerTalk

2

XlMarkerStyle

Constant

Value

xlMarkerStyleAutomatic

-4105

xlMarkerStyleCircle

8

xlMarkerStyleDash

-4115

xlMarkerStyleDiamond

2

xlMarkerStyleDot

-4118

xlMarkerStyleNone

-4142

xlMarkerStylePicture

-4147

xlMarkerStylePlus

9

xlMarkerStyleSquare

1

xlMarkerStyleStar

5

xlMarkerStyleTriangle

3

xlMarkerStyleX

-4168

XlMouseButton

Constant

Value

xlNoButton

0

xlPrimaryButton

1

xlSecondaryButton

2

XlMousePointer

Constant

Value

xlDefault

-4143

xlIBeam

3

xlNorthwestArrow

1

xlWait

2

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlMSApplication

Constant

Value

xlMicrosoftAccess

4

xlMicrosoftFoxPro

5

xlMicrosoftMail

3

xlMicrosoftPowerPoint

2

xlMicrosoftProject

6

xlMicrosoftSchedulePlus

7

xlMicrosoftWord

1

XlObjectSize

Constant

Value

xlFitToPage

2

xlFullPage

3

xlScreenSize

1

XlOLEType

Constant

Value

xlOLEControl

2

xlOLEEmbed

1

xlOLELink

0

XlOLEVerb

Constant

Value

xlVerbOpen

2

xlVerbPrimary

1

XlOrder

Constant

Value

xlDownThenOver

1

xlOverThenDown

2

XlOrientation

Constant

Value

xlDownward

-4170

xlHorizontal

-4128

xlUpward

-4171

xlVertical

-4166

XlPageBreak

Constant

Value

xlPageBreakAutomatic

-4105

xlPageBreakManual

-4135

xlPageBreakNone

-4142

XlPageBreakExtent

Constant

Value

xlPageBreakFull

1

xlPageBreakPartial

2

XlPageOrientation

Constant

Value

xlLandscape

2

xlPortrait

1

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPaperSize

Constant

Value

xlPaper10x14

16

xlPaper11x17

17

xlPaperA3

8

xlPaperA4

9

xlPaperA4Small

10

xlPaperA5

11

xlPaperB4

12

xlPaperB5

13

xlPaperCsheet

24

xlPaperDsheet

25

xlPaperEnvelope10

20

xlPaperEnvelope11

21

xlPaperEnvelope12

22

xlPaperEnvelope14

23

xlPaperEnvelope9

19

xlPaperEnvelopeB4

33

xlPaperEnvelopeB5

34

xlPaperEnvelopeB6

35

xlPaperEnvelopeC3

29

xlPaperEnvelopeC4

30

xlPaperEnvelopeC5

28

xlPaperEnvelopeC6

31

xlPaperEnvelopeC65

32

xlPaperEnvelopeDL

27

xlPaperEnvelopeItaly

36

xlPaperEnvelopeMonarch

37

xlPaperEnvelopePersonal

38

xlPaperEsheet

26

xlPaperExecutive

7

xlPaperFanfoldLegalGerman

41

xlPaperFanfoldStdGerman

40

xlPaperFanfoldUS

39

xlPaperFolio

14

xlPaperLedger

4

xlPaperLegal

5

xlPaperLetter

1

xlPaperLetterSmall

2

xlPaperNote

18

xlPaperQuarto

15

xlPaperStatement

6

xlPaperTabloid

3

xlPaperUser

256

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlParameterDataType

Constant

Value

xlParamTypeBigInt

-5

xlParamTypeBinary

-2

xlParamTypeBit

-7

xlParamTypeChar

1

xlParamTypeDate

9

xlParamTypeDecimal

3

xlParamTypeDouble

8

xlParamTypeFloat

6

xlParamTypeInteger

4

xlParamTypeLongVarBinary

-4

xlParamTypeLongVarChar

-1

xlParamTypeNumeric

2

xlParamTypeReal

7

xlParamTypeSmallInt

5

xlParamTypeTime

10

xlParamTypeTimestamp

11

xlParamTypeTinyInt

-6

xlParamTypeUnknown

0

xlParamTypeVarBinary

-3

xlParamTypeVarChar

12

xlParamTypeWChar

-8

XlParameterType

Constant

Value

xlConstant

1

xlPrompt

0

xlRange

2

XlPasteSpecialOperation

Constant

Value

xlPasteSpecialOperationAdd

2

xlPasteSpecialOperationDivide

5

xlPasteSpecialOperationMultiply

4

xlPasteSpecialOperationNone

-4142

xlPasteSpecialOperationSubtract

3

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPasteType

Constant

Value

xlPasteAll

-4104

xlPasteAllExceptBorders

7

xlPasteColumnWidths

8

xlPasteComments

-4144

xlPasteFormats

-4122

xlPasteFormulas

-4123

xlPasteFormulasAndNumberFormats

11

xlPasteValidation

6

xlPasteValues

-4163

xlPasteValuesAndNumberFormats

12

XlPattern

Constant

Value

xlPatternAutomatic

-4105

xlPatternChecker

9

xlPatternCrissCross

16

xlPatternDown

-4121

xlPatternGray16

17

xlPatternGray25

-4124

xlPatternGray50

-4125

xlPatternGray75

-4126

xlPatternGray8

18

xlPatternGrid

15

xlPatternHorizontal

-4128

xlPatternLightDown

13

xlPatternLightHorizontal

11

xlPatternLightUp

14

xlPatternLightVertical

12

xlPatternNone

-4142

xlPatternSemiGray75

10

xlPatternSolid

1

xlPatternUp

-4162

xlPatternVertical

-4166

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPhoneticAlignment

Constant

Value

xlPhoneticAlignCenter

2

xlPhoneticAlignDistributed

3

xlPhoneticAlignLeft

1

xlPhoneticAlignNoControl

0

XlPhoneticCharacterType

Constant

Value

xlHiragana

2

xlKatakana

1

xlKatakanaHalf

0

xlNoConversion

3

XlPictureAppearance

Constant

Value

xlPrinter

2

xlScreen

1

XlPictureConvertorType

Constant

Value

xlBMP

1

xlCGM

7

xlDRW

4

xlDXF

5

xlEPS

8

xlHGL

6

xlPCT

13

xlPCX

10

xlPIC

11

xlPLT

12

xlTIF

9

xlWMF

2

xlWPG

3

XlPivotCellType

Constant

Value

xlPivotCellBlankCell

9

xlPivotCellCustomSubtotal

7

xlPivotCellDataField

4

xlPivotCellDataPivotField

8

xlPivotCellGrandTotal

3

xlPivotCellPageFieldItem

6

xlPivotCellPivotField

5

xlPivotCellPivotItem

1

xlPivotCellSubtotal

2

xlPivotCellValue

0

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPivotFieldCalculation

Constant

Value

xlDifferenceFrom

2

xlIndex

9

xlNoAdditionalCalculation

-4143

xlPercentDifferenceFrom

4

xlPercentOf

3

xlPercentOfColumn

7

xlPercentOfRow

6

xlPercentOfTotal

8

xlRunningTotal

5

XlPivotFieldDataType

Constant

Value

xlDate

2

xlNumber

-4145

xlText

-4158

XlPivotFieldOrientation

Constant

Value

xlColumnField

2

xlDataField

4

xlHidden

0

xlPageField

3

xlRowField

1

XlPivotFormatType

Constant

Value

xlPTClassic

20

xlPTNone

21

xlReport1

0

xlReport10

9

xlReport2

1

xlReport3

2

xlReport4

3

xlReport5

4

xlReport6

5

xlReport7

6

xlReport8

7

xlReport9

8

xlTable1

10

xlTable10

19

xlTable2

11

xlTable3

12

xlTable4

13

xlTable5

14

xlTable6

15

xlTable7

16

xlTable8

17

xlTable9

18

XlPivotTableMissingItems

Constant

Value

xlMissingItemsDefault

-1

xlMissingItemsMax

32500

xlMissingItemsNone

0

XlPivotTableSourceType

Constant

Value

xlConsolidation

3

xlDatabase

1

xlExternal

2

xlPivotTable

-4148

xlScenario

4

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlPivotTableVersionList

Constant

Value

xlPivotTableVersion10

1

xlPivotTableVersion2000

0

xlPivotTableVersionCurrent

-1

XlPlacement

Constant

Value

xlFreeFloating

3

xlMove

2

xlMoveAndSize

1

XlPlatform

Constant

Value

xlMacintosh

1

xlMSDOS

3

xlWindows

2

XlPrintErrors

Constant

Value

xlPrintErrorsBlank

1

xlPrintErrorsDash

2

xlPrintErrorsDisplayed

0

xlPrintErrorsNA

3

XlPrintLocation

Constant

Value

xlPrintInPlace

16

xlPrintNoComments

-4142

xlPrintSheetEnd

1

XlPriority

Constant

Value

xlPriorityHigh

-4127

xlPriorityLow

-4134

xlPriorityNormal

-4143

XlPTSelectionMode

Constant

Value

xlBlanks

4

xlButton

15

xlDataAndLabel

0

xlDataOnly

2

xlFirstRow

256

xlLabelOnly

1

xlOrigin

3

XlQueryType

Constant

Value

xlADORecordset

7

xlDAORecordset

2

xlODBCQuery

1

xlOLEDBQuery

5

xlTextImport

6

xlWebQuery

4

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlRangeAutoFormat

Constant

Value

xlRangeAutoFormat3DEffects1

13

xlRangeAutoFormat3DEffects2

14

xlRangeAutoFormatAccounting1

4

xlRangeAutoFormatAccounting2

5

xlRangeAutoFormatAccounting3

6

xlRangeAutoFormatAccounting4

17

xlRangeAutoFormatClassic1

1

xlRangeAutoFormatClassic2

2

xlRangeAutoFormatClassic3

3

xlRangeAutoFormatClassicPivotTable

31

xlRangeAutoFormatColor1

7

xlRangeAutoFormatColor2

8

xlRangeAutoFormatColor3

9

xlRangeAutoFormatList1

10

xlRangeAutoFormatList2

11

xlRangeAutoFormatList3

12

xlRangeAutoFormatLocalFormat1

15

xlRangeAutoFormatLocalFormat2

16

xlRangeAutoFormatLocalFormat3

19

xlRangeAutoFormatLocalFormat4

20

xlRangeAutoFormatNone

-4142

xlRangeAutoFormatPTNone

42

xlRangeAutoFormatReport1

21

xlRangeAutoFormatReport10

30

xlRangeAutoFormatReport2

22

xlRangeAutoFormatReport3

23

xlRangeAutoFormatReport4

24

xlRangeAutoFormatReport5

25

xlRangeAutoFormatReport6

26

xlRangeAutoFormatReport7

27

xlRangeAutoFormatReport8

28

xlRangeAutoFormatReport9

29

xlRangeAutoFormatSimple

-4154

xlRangeAutoFormatTable1

32

xlRangeAutoFormatTable10

41

xlRangeAutoFormatTable2

33

xlRangeAutoFormatTable3

34

xlRangeAutoFormatTable4

35

xlRangeAutoFormatTable5

36

xlRangeAutoFormatTable6

37

xlRangeAutoFormatTable7

38

xlRangeAutoFormatTable8

39

xlRangeAutoFormatTable9

40

XlRangeValueDataType

Constant

Value

xlRangeValueDefault

10

xlRangeValueMSPersistXML

12

xlRangeValueXMLSpreadsheet

11

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlReferenceStyle

Constant

Value

xlA1

1

xlR1C1

-4150

XlReferenceType

Constant

Value

xlAbsolute

1

xlAbsRowRelColumn

2

xlRelative

4

xlRelRowAbsColumn

3

XlRobustConnect

Constant

Value

xlAlways

1

xlAsRequired

0

xlNever

2

XlRoutingSlipDelivery

Constant

Value

xlAllAtOnce

2

xlOneAfterAnother

1

XlRoutingSlipStatus

Constant

Value

xlNotYetRouted

0

xlRoutingComplete

2

xlRoutingInProgress

1

XlRowCol

Constant

Value

xlColumns

2

xlRows

1

XlRunAutoMacro

Constant

Value

xlAutoActivate

3

xlAutoClose

2

xlAutoDeactivate

4

xlAutoOpen

1

XlSaveAction

Constant

Value

xlDoNotSaveChanges

2

xlSaveChanges

1

XlSaveAsAccessMode

Constant

Value

xlExclusive

3

xlNoChange

1

xlShared

2

XlSaveConflictResolution

Constant

Value

xlLocalSessionChanges

2

xlOtherSessionChanges

3

xlUserResolution

1

XlScaleType

Constant

Value

xlScaleLinear

-4132

xlScaleLogarithmic

-4133

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSearchDirection

Constant

Value

xlNext

1

xlPrevious

2

XlSearchOrder

Constant

Value

xlByColumns

2

xlByRows

1

XlSearchWithin

Constant

Value

xlWithinSheet

1

xlWithinWorkbook

2

XlSheetType

Constant

Value

xlChart

-4109

xlDialogSheet

-4116

xlExcel4IntlMacroSheet

4

xlExcel4MacroSheet

3

xlWorksheet

-4167

XlSheetVisibility

Constant

Value

xlSheetHidden

0

xlSheetVeryHidden

2

xlSheetVisible

-1

XlSizeRepresents

Constant

Value

xlSizeIsArea

1

xlSizeIsWidth

2

XlSmartTagControlType

Constant

Value

xlSmartTagControlActiveX

13

xlSmartTagControlButton

6

xlSmartTagControlCheckbox

9

xlSmartTagControlCombo

12

xlSmartTagControlHelp

3

xlSmartTagControlHelpURL

4

xlSmartTagControlImage

8

xlSmartTagControlLabel

7

xlSmartTagControlLink

2

xlSmartTagControlListbox

11

xlSmartTagControlRadioGroup

14

xlSmartTagControlSeparator

5

xlSmartTagControlSmartTag

1

xlSmartTagControlTextbox

10

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSmartTagDisplayMode

Constant

Value

xlButtonOnly

2

xlDisplayNone

1

xlIndicatorAndButton

0

XlSortDataOption

Constant

Value

xlSortNormal

0

xlSortTextAsNumbers

1

XlSortMethod

Constant

Value

xlPinYin

1

xlStroke

2

XlSortMethodOld

Constant

Value

xlCodePage

2

xlSyllabary

1

XlSortOrder

Constant

Value

xlAscending

1

xlDescending

2

XlSortOrientation

Constant

Value

xlSortColumns

1

xlSortRows

2

XlSortType

Constant

Value

xlSortLabels

2

xlSortValues

1

XlSourceType

Constant

Value

xlSourceAutoFilter

3

xlSourceChart

5

xlSourcePivotTable

6

xlSourcePrintArea

2

xlSourceQuery

7

xlSourceRange

4

xlSourceSheet

1

xlSourceWorkbook

0

XlSpeakDirection

Constant

Value

xlSpeakByColumns

1

xlSpeakByRows

0

XlSpecialCellsValue

Constant

Value

xlErrors

16

xlLogical

4

xlNumbers

1

xlTextValues

2

XlSubscribeToFormat

Constant

Value

xlSubscribeToPicture

-4147

xlSubscribeToText

-4158

XlSubtototalLocationType

Constant

Value

xlAtBottom

2

xlAtTop

1

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlSummaryColumn

Constant

Value

xlSummaryOnLeft

-4131

xlSummaryOnRight

-4152

XlSummaryReportType

Constant

Value

xlStandardSummary

1

xlSummaryPivotTable

-4148

XlSummaryRow

Constant

Value

xlSummaryAbove

0

xlSummaryBelow

1

XlTabPosition

Constant

Value

xlTabPositionFirst

0

xlTabPositionLast

1

XlTextParsingType

Constant

Value

xlDelimited

1

xlFixedWidth

2

XlTextQualifier

Constant

Value

xlTextQualifierDoubleQuote

1

xlTextQualifierNone

-4142

xlTextQualifierSingleQuote

2

XlTextVisualLayoutType

Constant

Value

xlTextVisualLTR

1

xlTextVisualRTL

2

XlTickLabelOrientation

Constant

Value

xlTickLabelOrientationAutomatic

-4105

xlTickLabelOrientationDownward

-4170

xlTickLabelOrientationHorizontal

-4128

xlTickLabelOrientationUpward

-4171

xlTickLabelOrientationVertical

-4166

XlTickLabelPosition

Constant

Value

xlTickLabelPositionHigh

-4127

xlTickLabelPositionLow

-4134

xlTickLabelPositionNextToAxis

4

xlTickLabelPositionNone

-4142

XlTickMark

Constant

Value

xlTickMarkCross

4

xlTickMarkInside

2

xlTickMarkNone

-4142

xlTickMarkOutside

3

XlTimeUnit

Constant

Value

xlDays

0

xlMonths

1

xlYears

2

XlToolbarProtection

Constant

Value

xlNoButtonChanges

1

xlNoChanges

4

xlNoDockingChanges

3

xlNoShapeChanges

2

xlToolbarProtectionNone

-4143

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlTotalsCalculation

Constant

Value

xlTotalsCalculationAverage

2

xlTotalsCalculationCount

3

xlTotalsCalculationCountNums

4

xlTotalsCalculationMax

6

xlTotalsCalculationMin

5

xlTotalsCalculationNone

0

xlTotalsCalculationStdDev

7

xlTotalsCalculationSum

1

xlTotalsCalculationVar

8

XlTrendlineType

Constant

Value

xlExponential

5

xlLinear

-4132

xlLogarithmic

-4133

xlMovingAvg

6

xlPolynomial

3

xlPower

4

XlUnderlineStyle

Constant

Value

xlUnderlineStyleDouble

-4119

xlUnderlineStyleDoubleAccounting

5

xlUnderlineStyleNone

-4142

xlUnderlineStyleSingle

2

xlUnderlineStyleSingleAccounting

4

XlUpdateLinks

Constant

Value

xlUpdateLinksAlways

3

xlUpdateLinksNever

2

xlUpdateLinksUserSetting

1

XlVAlign

Constant

Value

xlVAlignBottom

-4107

xlVAlignCenter

-4108

xlVAlignDistributed

-4117

xlVAlignJustify

-4130

xlVAlignTop

-4160

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlWBATemplate

Constant

Value

xlWBATChart

-4109

xlWBATExcel4IntlMacroSheet

4

xlWBATExcel4MacroSheet

3

xlWBATWorksheet

-4167

XlWebFormatting

Constant

Value

xlWebFormattingAll

1

xlWebFormattingNone

3

xlWebFormattingRTF

2

XlWebSelectionType

Constant

Value

xlAllTables

2

xlEntirePage

1

xlSpecifiedTables

3

XlWindowState

Constant

Value

xlMaximized

-4137

xlMinimized

-4140

xlNormal

-4143

XlWindowType

Constant

Value

xlChartAsWindow

5

xlChartInPlace

4

xlClipboard

3

xlInfo

-4129

xlWorkbook

1

XlWindowView

Constant

Value

xlNormalView

1

xlPageBreakPreview

2

XlXLMMacroType

Constant

Value

xlCommand

2

xlFunction

1

xlNotXLM

3

XlXmlExportResult

Constant

Value

xlXmlExportSuccess

0

xlXmlExportValidationFailed

1

XlXmlImportResult

Constant

Value

xlXmlImportElementsTruncated

1

xlXmlImportSuccess

0

xlXmlImportValidationFailed

2

XlXmlLoadOption

Constant

Value

xlXmlLoadImportToList

2

xlXmlLoadMapXml

3

xlXmlLoadOpenXml

1

xlXmlLoadPromptUser

0

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2005-11-6 16:07:00 个人主页 | 引用 | 返回 | 删除 | 回复

XlYesNoGuess

Constant

Value

xlGuess

0

xlNo

2

xlYes

1

完了，excel里常用的常量都在这里，如果要在程序里操作excel的话呢，可以打开excel，然后呢，选菜单里的录制宏，然后呢，干你想要干的操作，录制完后呢，再强加宏，这样子就成在vba的编辑器里查到宏的代码了，刚才的操作如果成要用代码生成就成用这些宏的代码

不过宏里的代码用的全是常数来的，要转成数字才成在其它语言里用，这里成查到这些常数对应的数字

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复

{ XlSheetType }

xlChart = -4109;

xlDialogSheet = -4116;

xlExcel4IntlMacroSheet = 4;

xlExcel4MacroSheet = 3;

xlWorksheet = -4167;

{ XlWBATemplate }

xlWBATChart = -4109;

xlWBATExcel4IntlMacroSheet = 4;

xlWBATExcel4MacroSheet = 3;

xlWBATWorksheet = -4167;

{ XlPattern }

xlPatternAutomatic = -4105;

xlPatternChecker = 9;

xlPatternCrissCross = 16;

xlPatternDown = -4121;

xlPatternGray16 = 17;

xlPatternGray25 = -4124;

xlPatternGray50 = -4125;

xlPatternGray75 = -4126;

xlPatternGray8 = 18;

xlPatternGrid = 15;

xlPatternHorizontal = -4128;

xlPatternLightDown = 13;

xlPatternLightHorizontal = 11;

xlPatternLightUp = 14;

xlPatternLightVertical = 12;

xlPatternNone = -4142;

xlPatternSemiGray75 = 10;

xlPatternSolid = 1;

xlPatternUp = -4162;

xlPatternVertical = -4166;

{ XlBordersIndex }

xlInsideHorizontal = 12;

xlInsideVertical = 11;

xlDiagonalDown = 5;

xlDiagonalUp = 6;

xlEdgeBottom = 9;

xlEdgeLeft = 7;

xlEdgeRight = 10;

xlEdgeTop = 8;

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复

{ XlLineStyle }

xlContinuous = 1;

xlDash = -4115;

xlDashDot = 4;

xlDashDotDot = 5;

xlDot = -4118;

xlDouble = -4119;

xlSlantDashDot = 13;

xlLineStyleNone = -4142;

{ 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 = -4100;

xlLine = 4;

xl3DLine = -4101;

xl3DPie = -4102;

xlPie = 5;

xlXYScatter = -4169;

xl3DArea = -4098;

xlArea = 1;

xlDoughnut = -4120;

xlRadar = -4151;

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 18:34:00 个人主页 | 引用 | 返回 | 删除 | 回复

{ Various Constants }

xlAll = -4104;

xlAutomatic = -4105;

xlBoth = 1;

xlCenter = -4108;

xlChecker = 9;

xlCircle = 8;

xlCorner = 2;

xlCrissCross = 16;

xlCross = 4;

xlDiamond = 2;

xlDistributed = -4117;

xlDoubleAccounting = 5;

xlFixedvalue = 1;

xlFormats = -4122;

xlGray16 = 17;

xlGray8 = 18;

xlGrid = 15;

xlHigh = -4127;

xlInside = 2;

xlJustify = -4130;

xlLightDown = 13;

xlLightHorizontal = 11;

xlLightUp = 14;

xlLightVertical = 12;

xlLow = -4134;

xlManual = -4135;

xlMinusvalues = 3;

xlModule = -4141;

xlNextToAxis = 4;

xlNone = -4142;

xlNotes = -4144;

xlOff = -4146;

xlOn = 1;

xlPercent = 2;

xlPlus = 9;

xlPlusvalues = 2;

xlSemiGray75 = 10;

xlShowLabel = 4;

xlShowLabelAndPercent = 5;

xlShowPercent = 3;

xlShowvalue = 2;

xlSimple = -4154;

xlSingle = 2;

xlSingleAccounting = 4;

xlSolid = 1;

xlSquare = 1;

xlStar = 5;

xlStError = 4;

xlToolbarButton = 2;

xlTriangle = 3;

xlGray25 = -4124;

xlGray50 = -4125;

xlGray75 = -4126;

xlBottom = -4107;

xlLeft = -4131;

xlRight = -4152;

xlTop = -4160;

xl3DBar = -4099;

xl3DSurface = -4103;

xlBar = 2;

xlColumn = 3;

xlCombination = -4111;

xlCustom = -4114;

xlDefaultAutoFormat = -1;

xlMaximum = 2;

xlMinimum = 4;

xlOpaque = 3;

xlTransparent = 2;

xlBidi = -5000;

xlLatin = -5001;

xlContext = -5002;

xlLTR = -5003;

xlRTL = -5004;

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;

xlNodocument． = 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;

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoLineDashStyle

{

msoLineDashStyleMixed = -2,

msoLineSolid = 1,

msoLineSquareDot = 2,

msoLineRoundDot = 3,

msoLineDash = 4,

msoLineDashDot = 5,

msoLineDashDotDot = 6,

msoLineLongDash = 7,

msoLineLongDashDot = 8

};

enum MsoLineStyle

{

msoLineStyleMixed = -2,

msoLineSingle = 1,

msoLineThinThin = 2,

msoLineThinThick = 3,

msoLineThickThin = 4,

msoLineThickBetweenThin = 5

};

enum MsoArrowheadStyle

{

msoArrowheadStyleMixed = -2,

msoArrowheadNone = 1,

msoArrowheadTriangle = 2,

msoArrowheadOpen = 3,

msoArrowheadStealth = 4,

msoArrowheadDiamond = 5,

msoArrowheadOval = 6

};

enum MsoArrowheadWidth

{

msoArrowheadWidthMixed = -2,

msoArrowheadNarrow = 1,

msoArrowheadWidthMedium = 2,

msoArrowheadWide = 3

};

enum MsoArrowheadLength

{

msoArrowheadLengthMixed = -2,

msoArrowheadShort = 1,

msoArrowheadLengthMedium = 2,

msoArrowheadLong = 3

};

enum MsoFillType

{

msoFillMixed = -2,

msoFillSolid = 1,

msoFillPatterned = 2,

msoFillGradient = 3,

msoFillTextured = 4,

msoFillBackground = 5,

msoFillPicture = 6

};

enum MsoGradientStyle

{

msoGradientMixed = -2,

msoGradientHorizontal = 1,

msoGradientVertical = 2,

msoGradientDiagonalUp = 3,

msoGradientDiagonalDown = 4,

msoGradientFromCorner = 5,

msoGradientFromTitle = 6,

msoGradientFromCenter = 7

};

enum MsoGradientColorType

{

msoGradientColorMixed = -2,

msoGradientOneColor = 1,

msoGradientTwoColors = 2,

msoGradientPresetColors = 3

};

enum MsoTextureType

{

msoTextureTypeMixed = -2,

msoTexturePreset = 1,

msoTextureUserDefined = 2

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoPresetTexture

{

msoPresetTextureMixed = -2,

msoTexturePapyrus = 1,

msoTextureCanvas = 2,

msoTextureDenim = 3,

msoTextureWovenMat = 4,

msoTextureWaterDroplets = 5,

msoTexturePaperBag = 6,

msoTextureFishFossil = 7,

msoTextureSand = 8,

msoTextureGreenMarble = 9,

msoTextureWhiteMarble = 10,

msoTextureBrownMarble = 11,

msoTextureGranite = 12,

msoTextureNewsprint = 13,

msoTextureRecycledPaper = 14,

msoTextureParchment = 15,

msoTextureStationery = 16,

msoTextureBlueTissuePaper = 17,

msoTexturePinkTissuePaper = 18,

msoTexturePurpleMesh = 19,

msoTextureBouquet = 20,

msoTextureCork = 21,

msoTextureWalnut = 22,

msoTextureOak = 23,

msoTextureMediumWood = 24

};

enum MsoPatternType

{

msoPatternMixed = -2,

msoPattern5Percent = 1,

msoPattern10Percent = 2,

msoPattern20Percent = 3,

msoPattern25Percent = 4,

msoPattern30Percent = 5,

msoPattern40Percent = 6,

msoPattern50Percent = 7,

msoPattern60Percent = 8,

msoPattern70Percent = 9,

msoPattern75Percent = 10,

msoPattern80Percent = 11,

msoPattern90Percent = 12,

msoPatternDarkHorizontal = 13,

msoPatternDarkVertical = 14,

msoPatternDarkDownwardDiagonal = 15,

msoPatternDarkUpwardDiagonal = 16,

msoPatternSmallCheckerBoard = 17,

msoPatternTrellis = 18,

msoPatternLightHorizontal = 19,

msoPatternLightVertical = 20,

msoPatternLightDownwardDiagonal = 21,

msoPatternLightUpwardDiagonal = 22,

msoPatternSmallGrid = 23,

msoPatternDottedDiamond = 24,

msoPatternWideDownwardDiagonal = 25,

msoPatternWideUpwardDiagonal = 26,

msoPatternDashedUpwardDiagonal = 27,

msoPatternDashedDownwardDiagonal = 28,

msoPatternNarrowVertical = 29,

msoPatternNarrowHorizontal = 30,

msoPatternDashedVertical = 31,

msoPatternDashedHorizontal = 32,

msoPatternLargeConfetti = 33,

msoPatternLargeGrid = 34,

msoPatternHorizontalBrick = 35,

msoPatternLargeCheckerBoard = 36,

msoPatternSmallConfetti = 37,

msoPatternZigZag = 38,

msoPatternSolidDiamond = 39,

msoPatternDiagonalBrick = 40,

msoPatternOutlinedDiamond = 41,

msoPatternPlaid = 42,

msoPatternSphere = 43,

msoPatternWeave = 44,

msoPatternDottedGrid = 45,

msoPatternDivot = 46,

msoPatternShingle = 47,

msoPatternWave = 48

};

enum MsoPresetGradientType

{

msoPresetGradientMixed = -2,

msoGradientEarlySunset = 1,

msoGradientLateSunset = 2,

msoGradientNightfall = 3,

msoGradientDaybreak = 4,

msoGradientHorizon = 5,

msoGradientDesert = 6,

msoGradientOcean = 7,

msoGradientCalmWater = 8,

msoGradientFire = 9,

msoGradientFog = 10,

msoGradientMoss = 11,

msoGradientPeacock = 12,

msoGradientWheat = 13,

msoGradientParchment = 14,

msoGradientMahogany = 15,

msoGradientRainbow = 16,

msoGradientRainbowII = 17,

msoGradientGold = 18,

msoGradientGoldII = 19,

msoGradientBrass = 20,

msoGradientChrome = 21,

msoGradientChromeII = 22,

msoGradientSilver = 23,

msoGradientSapphire = 24

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:20:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoShadowType

{

msoShadowMixed = -2,

msoShadow1 = 1,

msoShadow2 = 2,

msoShadow3 = 3,

msoShadow4 = 4,

msoShadow5 = 5,

msoShadow6 = 6,

msoShadow7 = 7,

msoShadow8 = 8,

msoShadow9 = 9,

msoShadow10 = 10,

msoShadow11 = 11,

msoShadow12 = 12,

msoShadow13 = 13,

msoShadow14 = 14,

msoShadow15 = 15,

msoShadow16 = 16,

msoShadow17 = 17,

msoShadow18 = 18,

msoShadow19 = 19,

msoShadow20 = 20

};

enum MsoPresetTextEffect

{

msoTextEffectMixed = -2,

msoTextEffect1 = 0,

msoTextEffect2 = 1,

msoTextEffect3 = 2,

msoTextEffect4 = 3,

msoTextEffect5 = 4,

msoTextEffect6 = 5,

msoTextEffect7 = 6,

msoTextEffect8 = 7,

msoTextEffect9 = 8,

msoTextEffect10 = 9,

msoTextEffect11 = 10,

msoTextEffect12 = 11,

msoTextEffect13 = 12,

msoTextEffect14 = 13,

msoTextEffect15 = 14,

msoTextEffect16 = 15,

msoTextEffect17 = 16,

msoTextEffect18 = 17,

msoTextEffect19 = 18,

msoTextEffect20 = 19,

msoTextEffect21 = 20,

msoTextEffect22 = 21,

msoTextEffect23 = 22,

msoTextEffect24 = 23,

msoTextEffect25 = 24,

msoTextEffect26 = 25,

msoTextEffect27 = 26,

msoTextEffect28 = 27,

msoTextEffect29 = 28,

msoTextEffect30 = 29

};

enum MsoPresetTextEffectShape

{

msoTextEffectShapeMixed = -2,

msoTextEffectShapePlainText = 1,

msoTextEffectShapeStop = 2,

msoTextEffectShapeTriangleUp = 3,

msoTextEffectShapeTriangleDown = 4,

msoTextEffectShapeChevronUp = 5,

msoTextEffectShapeChevronDown = 6,

msoTextEffectShapeRingInside = 7,

msoTextEffectShapeRingOutside = 8,

msoTextEffectShapeArchUpCurve = 9,

msoTextEffectShapeArchDownCurve = 10,

msoTextEffectShapeCircleCurve = 11,

msoTextEffectShapeButtonCurve = 12,

msoTextEffectShapeArchUpPour = 13,

msoTextEffectShapeArchDownPour = 14,

msoTextEffectShapeCirclePour = 15,

msoTextEffectShapeButtonPour = 16,

msoTextEffectShapeCurveUp = 17,

msoTextEffectShapeCurveDown = 18,

msoTextEffectShapeCanUp = 19,

msoTextEffectShapeCanDown = 20,

msoTextEffectShapeWave1 = 21,

msoTextEffectShapeWave2 = 22,

msoTextEffectShapeDoubleWave1 = 23,

msoTextEffectShapeDoubleWave2 = 24,

msoTextEffectShapeInflate = 25,

msoTextEffectShapeDeflate = 26,

msoTextEffectShapeInflateBottom = 27,

msoTextEffectShapeDeflateBottom = 28,

msoTextEffectShapeInflateTop = 29,

msoTextEffectShapeDeflateTop = 30,

msoTextEffectShapeDeflateInflate = 31,

msoTextEffectShapeDeflateInflateDeflate = 32,

msoTextEffectShapeFadeRight = 33,

msoTextEffectShapeFadeLeft = 34,

msoTextEffectShapeFadeUp = 35,

msoTextEffectShapeFadeDown = 36,

msoTextEffectShapeSlantUp = 37,

msoTextEffectShapeSlantDown = 38,

msoTextEffectShapeCascadeUp = 39,

msoTextEffectShapeCascadeDown = 40

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:20:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoTextEffectAlignment

{

msoTextEffectAlignmentMixed = -2,

msoTextEffectAlignmentLeft = 1,

msoTextEffectAlignmentCentered = 2,

msoTextEffectAlignmentRight = 3,

msoTextEffectAlignmentLetterJustify = 4,

msoTextEffectAlignmentWordJustify = 5,

msoTextEffectAlignmentStretchJustify = 6

};

enum MsoPresetLightingDirection

{

msoPresetLightingDirectionMixed = -2,

msoLightingTopLeft = 1,

msoLightingTop = 2,

msoLightingTopRight = 3,

msoLightingLeft = 4,

msoLightingNone = 5,

msoLightingRight = 6,

msoLightingBottomLeft = 7,

msoLightingBottom = 8,

msoLightingBottomRight = 9

};

enum MsoPresetLightingSoftness

{

msoPresetLightingSoftnessMixed = -2,

msoLightingDim = 1,

msoLightingNormal = 2,

msoLightingBright = 3

};

enum MsoPresetMaterial

{

msoPresetMaterialMixed = -2,

msoMaterialMatte = 1,

msoMaterialPlastic = 2,

msoMaterialMetal = 3,

msoMaterialWireFrame = 4

};

enum MsoPresetExtrusionDirection

{

msoPresetExtrusionDirectionMixed = -2,

msoExtrusionBottomRight = 1,

msoExtrusionBottom = 2,

msoExtrusionBottomLeft = 3,

msoExtrusionRight = 4,

msoExtrusionNone = 5,

msoExtrusionLeft = 6,

msoExtrusionTopRight = 7,

msoExtrusionTop = 8,

msoExtrusionTopLeft = 9

};

enum MsoPresetThreeDFormat

{

msoPresetThreeDFormatMixed = -2,

msoThreeD1 = 1,

msoThreeD2 = 2,

msoThreeD3 = 3,

msoThreeD4 = 4,

msoThreeD5 = 5,

msoThreeD6 = 6,

msoThreeD7 = 7,

msoThreeD8 = 8,

msoThreeD9 = 9,

msoThreeD10 = 10,

msoThreeD11 = 11,

msoThreeD12 = 12,

msoThreeD13 = 13,

msoThreeD14 = 14,

msoThreeD15 = 15,

msoThreeD16 = 16,

msoThreeD17 = 17,

msoThreeD18 = 18,

msoThreeD19 = 19,

msoThreeD20 = 20

};

enum MsoExtrusionColorType

{

msoExtrusionColorTypeMixed = -2,

msoExtrusionColorAutomatic = 1,

msoExtrusionColorCustom = 2

};

enum MsoAlignCmd

{

msoAlignLefts = 0,

msoAlignCenters = 1,

msoAlignRights = 2,

msoAlignTops = 3,

msoAlignMiddles = 4,

msoAlignBottoms = 5

};

enum MsoDistributeCmd

{

msoDistributeHorizontally = 0,

msoDistributeVertically = 1

};

enum MsoConnectorType

{

msoConnectorTypeMixed = -2,

msoConnectorStraight = 1,

msoConnectorElbow = 2,

msoConnectorCurve = 3

};

enum MsoHorizontalAnchor

{

msoHorizontalAnchorMixed = -2,

msoAnchorNone = 1,

msoAnchorCenter = 2

};

enum MsoVerticalAnchor

{

msoVerticalAnchorMixed = -2,

msoAnchorTop = 1,

msoAnchorTopBaseline = 2,

msoAnchorMiddle = 3,

msoAnchorBottom = 4,

msoAnchorBottomBaseLine = 5

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:21:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoOrientation

{

msoOrientationMixed = -2,

msoOrientationHorizontal = 1,

msoOrientationVertical = 2

};

enum MsoZOrderCmd

{

msoBringToFront = 0,

msoSendToBack = 1,

msoBringForward = 2,

msoSendBackward = 3,

msoBringInFrontOfText = 4,

msoSendBehindText = 5

};

enum MsoSegmentType

{

msoSegmentLine = 0,

msoSegmentCurve = 1

};

enum MsoEditingType

{

msoEditingAuto = 0,

msoEditingCorner = 1,

msoEditingSmooth = 2,

msoEditingSymmetric = 3

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:21:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoAutoShapeType

{

msoShapeMixed = -2,

msoShapeRectangle = 1,

msoShapeParallelogram = 2,

msoShapeTrapezoid = 3,

msoShapeDiamond = 4,

msoShapeRoundedRectangle = 5,

msoShapeOctagon = 6,

msoShapeIsoscelesTriangle = 7,

msoShapeRightTriangle = 8,

msoShapeOval = 9,

msoShapeHexagon = 10,

msoShapeCross = 11,

msoShapeRegularPentagon = 12,

msoShapeCan = 13,

msoShapeCube = 14,

msoShapeBevel = 15,

msoShapeFoldedCorner = 16,

msoShapeSmileyFace = 17,

msoShapeDonut = 18,

msoShapeNoSymbol = 19,

msoShapeBlockArc = 20,

msoShapeHeart = 21,

msoShapeLightningBolt = 22,

msoShapeSun = 23,

msoShapeMoon = 24,

msoShapeArc = 25,

msoShapeDoubleBracket = 26,

msoShapeDoubleBrace = 27,

msoShapePlaque = 28,

msoShapeLeftBracket = 29,

msoShapeRightBracket = 30,

msoShapeLeftBrace = 31,

msoShapeRightBrace = 32,

msoShapeRightArrow = 33,

msoShapeLeftArrow = 34,

msoShapeUpArrow = 35,

msoShapeDownArrow = 36,

msoShapeLeftRightArrow = 37,

msoShapeUpDownArrow = 38,

msoShapeQuadArrow = 39,

msoShapeLeftRightUpArrow = 40,

msoShapeBentArrow = 41,

msoShapeUTurnArrow = 42,

msoShapeLeftUpArrow = 43,

msoShapeBentUpArrow = 44,

msoShapeCurvedRightArrow = 45,

msoShapeCurvedLeftArrow = 46,

msoShapeCurvedUpArrow = 47,

msoShapeCurvedDownArrow = 48,

msoShapeStripedRightArrow = 49,

msoShapeNotchedRightArrow = 50,

msoShapePentagon = 51,

msoShapeChevron = 52,

msoShapeRightArrowCallout = 53,

msoShapeLeftArrowCallout = 54,

msoShapeUpArrowCallout = 55,

msoShapeDownArrowCallout = 56,

msoShapeLeftRightArrowCallout = 57,

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复

msoShapeUpDownArrowCallout = 58,

msoShapeQuadArrowCallout = 59,

msoShapeCircularArrow = 60,

msoShapeFlowchartProcess = 61,

msoShapeFlowchartAlternateProcess = 62,

msoShapeFlowchartDecision = 63,

msoShapeFlowchartData = 64,

msoShapeFlowchartPredefinedProcess = 65,

msoShapeFlowchartInternalStorage = 66,

msoShapeFlowchartDocument = 67,

msoShapeFlowchartMultidocument = 68,

msoShapeFlowchartTerminator = 69,

msoShapeFlowchartPreparation = 70,

msoShapeFlowchartManualInput = 71,

msoShapeFlowchartManualOperation = 72,

msoShapeFlowchartConnector = 73,

msoShapeFlowchartOffpageConnector = 74,

msoShapeFlowchartCard = 75,

msoShapeFlowchartPunchedTape = 76,

msoShapeFlowchartSummingJunction = 77,

msoShapeFlowchartOr = 78,

msoShapeFlowchartCollate = 79,

msoShapeFlowchartSort = 80,

msoShapeFlowchartExtract = 81,

msoShapeFlowchartMerge = 82,

msoShapeFlowchartStoredData = 83,

msoShapeFlowchartDelay = 84,

msoShapeFlowchartSequentialAccessStorage = 85,

msoShapeFlowchartMagneticDisk = 86,

msoShapeFlowchartDirectAccessStorage = 87,

msoShapeFlowchartDisplay = 88,

msoShapeExplosion1 = 89,

msoShapeExplosion2 = 90,

msoShape4pointStar = 91,

msoShape5pointStar = 92,

msoShape8pointStar = 93,

msoShape16pointStar = 94,

msoShape24pointStar = 95,

msoShape32pointStar = 96,

msoShapeUpRibbon = 97,

msoShapeDownRibbon = 98,

msoShapeCurvedUpRibbon = 99,

msoShapeCurvedDownRibbon = 100,

msoShapeVerticalScroll = 101,

msoShapeHorizontalScroll = 102,

msoShapeWave = 103,

msoShapeDoubleWave = 104,

msoShapeRectangularCallout = 105,

msoShapeRoundedRectangularCallout = 106,

msoShapeOvalCallout = 107,

msoShapeCloudCallout = 108,

msoShapeLineCallout1 = 109,

msoShapeLineCallout2 = 110,

msoShapeLineCallout3 = 111,

msoShapeLineCallout4 = 112,

msoShapeLineCallout1AccentBar = 113,

msoShapeLineCallout2AccentBar = 114,

msoShapeLineCallout3AccentBar = 115,

msoShapeLineCallout4AccentBar = 116,

msoShapeLineCallout1NoBorder = 117,

msoShapeLineCallout2NoBorder = 118,

msoShapeLineCallout3NoBorder = 119,

msoShapeLineCallout4NoBorder = 120,

msoShapeLineCallout1BorderandAccentBar = 121,

msoShapeLineCallout2BorderandAccentBar = 122,

msoShapeLineCallout3BorderandAccentBar = 123,

msoShapeLineCallout4BorderandAccentBar = 124,

msoShapeActionButtonCustom = 125,

msoShapeActionButtonHome = 126,

msoShapeActionButtonHelp = 127,

msoShapeActionButtonInformation = 128,

msoShapeActionButtonBackorPrevious = 129,

msoShapeActionButtonForwardorNext = 130,

msoShapeActionButtonBeginning = 131,

msoShapeActionButtonEnd = 132,

msoShapeActionButtonReturn = 133,

msoShapeActionButtonDocument = 134,

msoShapeActionButtonSound = 135,

msoShapeActionButtonMovie = 136,

msoShapeBalloon = 137,

msoShapeNotPrimitive = 138

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoShapeType

{

msoShapeTypeMixed = -2,

msoAutoShape = 1,

msoCallout = 2,

msoChart = 3,

msoComment = 4,

msoFreeform = 5,

msoGroup = 6,

msoEmbeddedOLEObject = 7,

msoFormControl = 8,

msoLine = 9,

msoLinkedOLEObject = 10,

msoLinkedPicture = 11,

msoOLEControlObject = 12,

msoPicture = 13,

msoPlaceholder = 14,

msoTextEffect = 15,

msoMedia = 16,

msoTextBox = 17,

msoScriptAnchor = 18,

msoTable = 19,

msoCanvas = 20,

msoDiagram = 21

};

enum MsoFlipCmd

{

msoFlipHorizontal = 0,

msoFlipVertical = 1

};

enum MsoTriState

{

msoTrue = -1,

msoFalse = 0,

msoCTrue = 1,

msoTriStateToggle = -3,

msoTriStateMixed = -2

};

enum MsoColorType

{

msoColorTypeMixed = -2,

msoColorTypeRGB = 1,

msoColorTypeScheme = 2,

msoColorTypeCMYK = 3,

msoColorTypeCMS = 4,

msoColorTypeInk = 5

};

enum MsoPictureColorType

{

msoPictureMixed = -2,

msoPictureAutomatic = 1,

msoPictureGrayscale = 2,

msoPictureBlackAndWhite = 3,

msoPictureWatermark = 4

};

enum MsoCalloutAngleType

{

msoCalloutAngleMixed = -2,

msoCalloutAngleAutomatic = 1,

msoCalloutAngle30 = 2,

msoCalloutAngle45 = 3,

msoCalloutAngle60 = 4,

msoCalloutAngle90 = 5

};

enum MsoCalloutDropType

{

msoCalloutDropMixed = -2,

msoCalloutDropCustom = 1,

msoCalloutDropTop = 2,

msoCalloutDropCenter = 3,

msoCalloutDropBottom = 4

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoCalloutType

{

msoCalloutMixed = -2,

msoCalloutOne = 1,

msoCalloutTwo = 2,

msoCalloutThree = 3,

msoCalloutFour = 4

};

enum MsoBlackWhiteMode

{

msoBlackWhiteMixed = -2,

msoBlackWhiteAutomatic = 1,

msoBlackWhiteGrayScale = 2,

msoBlackWhiteLightGrayScale = 3,

msoBlackWhiteInverseGrayScale = 4,

msoBlackWhiteGrayOutline = 5,

msoBlackWhiteBlackTextAndLine = 6,

msoBlackWhiteHighContrast = 7,

msoBlackWhiteBlack = 8,

msoBlackWhiteWhite = 9,

msoBlackWhiteDontShow = 10

};

enum MsoMixedType

{

msoIntegerMixed = 32768,

msoSingleMixed = -2147483648

};

enum MsoTextOrientation

{

msoTextOrientationMixed = -2,

msoTextOrientationHorizontal = 1,

msoTextOrientationUpward = 2,

msoTextOrientationDownward = 3,

msoTextOrientationVerticalFarEast = 4,

msoTextOrientationVertical = 5,

msoTextOrientationHorizontalRotatedFarEast = 6

};

enum MsoScaleFrom

{

msoScaleFromTopLeft = 0,

msoScaleFromMiddle = 1,

msoScaleFromBottomRight = 2

};

enum MsoBarPosition

{

msoBarLeft = 0,

msoBarTop = 1,

msoBarRight = 2,

msoBarBottom = 3,

msoBarFloating = 4,

msoBarPopup = 5,

msoBarMenuBar = 6

};

enum MsoBarProtection

{

msoBarNoProtection = 0,

msoBarNoCustomize = 1,

msoBarNoResize = 2,

msoBarNoMove = 4,

msoBarNoChangeVisible = 8,

msoBarNoChangeDock = 16,

msoBarNoVerticalDock = 32,

msoBarNoHorizontalDock = 64

};

enum MsoBarType

{

msoBarTypeNormal = 0,

msoBarTypeMenuBar = 1,

msoBarTypePopup = 2

};

enum MsoControlType

{

msoControlCustom = 0,

msoControlButton = 1,

msoControlEdit = 2,

msoControlDropdown = 3,

msoControlComboBox = 4,

msoControlButtonDropdown = 5,

msoControlSplitDropdown = 6,

msoControlOCXDropdown = 7,

msoControlGenericDropdown = 8,

msoControlGraphicDropdown = 9,

msoControlPopup = 10,

msoControlGraphicPopup = 11,

msoControlButtonPopup = 12,

msoControlSplitButtonPopup = 13,

msoControlSplitButtonMRUPopup = 14,

msoControlLabel = 15,

msoControlExpandingGrid = 16,

msoControlSplitExpandingGrid = 17,

msoControlGrid = 18,

msoControlGauge = 19,

msoControlGraphicCombo = 20,

msoControlPane = 21,

msoControlActiveX = 22,

msoControlSpinner = 23,

msoControlLabelEx = 24,

msoControlWorkPane = 25,

msoControlAutoCompleteCombo = 26

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:22:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoButtonState

{

msoButtonUp = 0,

msoButtonDown = -1,

msoButtonMixed = 2

};

enum MsoControlOLEUsage

{

msoControlOLEUsageNeither = 0,

msoControlOLEUsageServer = 1,

msoControlOLEUsageClient = 2,

msoControlOLEUsageBoth = 3

};

enum MsoButtonStyleHidden

{

msoButtonWrapText = 4,

msoButtonTextBelow = 8

};

enum MsoButtonStyle

{

msoButtonAutomatic = 0,

msoButtonIcon = 1,

msoButtonCaption = 2,

msoButtonIconAndCaption = 3,

msoButtonIconAndWrapCaption = 7,

msoButtonIconAndCaptionBelow = 11,

msoButtonWrapCaption = 14,

msoButtonIconAndWrapCaptionBelow = 15

};

enum MsoComboStyle

{

msoComboNormal = 0,

msoComboLabel = 1

};

enum MsoOLEMenuGroup

{

msoOLEMenuGroupNone = -1,

msoOLEMenuGroupFile = 0,

msoOLEMenuGroupEdit = 1,

msoOLEMenuGroupContainer = 2,

msoOLEMenuGroupObject = 3,

msoOLEMenuGroupWindow = 4,

msoOLEMenuGroupHelp = 5

};

enum MsoMenuAnimation

{

msoMenuAnimationNone = 0,

msoMenuAnimationRandom = 1,

msoMenuAnimationUnfold = 2,

msoMenuAnimationSlide = 3

};

enum MsoBarRow

{

msoBarRowFirst = 0,

msoBarRowLast = -1

};

enum MsoCommandBarButtonHyperlinkType

{

msoCommandBarButtonHyperlinkNone = 0,

msoCommandBarButtonHyperlinkOpen = 1,

msoCommandBarButtonHyperlinkInsertPicture = 2

};

enum MsoHyperlinkType

{

msoHyperlinkRange = 0,

msoHyperlinkShape = 1,

msoHyperlinkInlineShape = 2

};

enum MsoExtraInfoMethod

{

msoMethodGet = 0,

msoMethodPost = 1

};

enum MsoAnimationType

{

msoAnimationIdle = 1,

msoAnimationGreeting = 2,

msoAnimationGoodbye = 3,

msoAnimationBeginSpeaking = 4,

msoAnimationRestPose = 5,

msoAnimationCharacterSuccessMajor = 6,

msoAnimationGetAttentionMajor = 11,

msoAnimationGetAttentionMinor = 12,

msoAnimationSearching = 13,

msoAnimationPrinting = 18,

msoAnimationGestureRight = 19,

msoAnimationWritingNotingSomething = 22,

msoAnimationWorkingAtSomething = 23,

msoAnimationThinking = 24,

msoAnimationSendingMail = 25,

msoAnimationListensToComputer = 26,

msoAnimationDisappear = 31,

msoAnimationAppear = 32,

msoAnimationGetArtsy = 100,

msoAnimationGetTechy = 101,

msoAnimationGetWizardy = 102,

msoAnimationCheckingSomething = 103,

msoAnimationLookDown = 104,

msoAnimationLookDownLeft = 105,

msoAnimationLookDownRight = 106,

msoAnimationLookLeft = 107,

msoAnimationLookRight = 108,

msoAnimationLookUp = 109,

msoAnimationLookUpLeft = 110,

msoAnimationLookUpRight = 111,

msoAnimationSaving = 112,

msoAnimationGestureDown = 113,

msoAnimationGestureLeft = 114,

msoAnimationGestureUp = 115,

msoAnimationEmptyTrash = 116

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-3-25 21:23:00 个人主页 | 引用 | 返回 | 删除 | 回复

enum MsoButtonSetType

{

msoButtonSetNone = 0,

msoButtonSetOK = 1,

msoButtonSetCancel = 2,

msoButtonSetOkCancel = 3,

msoButtonSetYesNo = 4,

msoButtonSetYesNoCancel = 5,

msoButtonSetBackClose = 6,

msoButtonSetNextClose = 7,

msoButtonSetBackNextClose = 8,

msoButtonSetRetryCancel = 9,

msoButtonSetAbortRetryIgnore = 10,

msoButtonSetSearchClose = 11,

msoButtonSetBackNextSnooze = 12,

msoButtonSetTipsOptionsClose = 13,

msoButtonSetYesAllNoCancel = 14

};

enum MsoIconType

{

msoIconNone = 0,

msoIconAlert = 2,

msoIconTip = 3,

msoIconAlertInfo = 4,

msoIconAlertWarning = 5,

msoIconAlertQuery = 6,

msoIconAlertCritical = 7

};

enum MsoBalloonType

{

msoBalloonTypeButtons = 0,

msoBalloonTypeBullets = 1,

msoBalloonTypeNumbers = 2

};

enum MsoModeType

{

msoModeModal = 0,

msoModeAutoDown = 1,

msoModeModeless = 2

};

enum MsoBalloonErrorType

{

msoBalloonErrorNone = 0,

msoBalloonErrorOther = 1,

msoBalloonErrorTooBig = 2,

msoBalloonErrorOutOfMemory = 3,

msoBalloonErrorBadPictureRef = 4,

msoBalloonErrorBadReference = 5,

msoBalloonErrorButtonlessModal = 6,

msoBalloonErrorButtonModeless = 7,

msoBalloonErrorBadCharacter = 8,

msoBalloonErrorCOMFailure = 9,

msoBalloonErrorCharNotTopmostForModal = 10,

msoBalloonErrorTooManyControls = 11

};

enum MsoWizardActType

{

msoWizardActInactive = 0,

msoWizardActActive = 1,

msoWizardActSuspend = 2,

msoWizardActResume = 3

};

enum MsoWizardMsgType

{

msoWizardMsgLocalStateOn = 1,

msoWizardMsgLocalStateOff = 2,

msoWizardMsgShowHelp = 3,

msoWizardMsgSuspending = 4,

msoWizardMsgResuming = 5

};

enum MsoBalloonButtonType

{

msoBalloonButtonYesToAll = -15,

msoBalloonButtonOptions = -14,

msoBalloonButtonTips = -13,

msoBalloonButtonClose = -12,

msoBalloonButtonSnooze = -11,

msoBalloonButtonSearch = -10,

msoBalloonButtonIgnore = -9,

msoBalloonButtonAbort = -8,

msoBalloonButtonRetry = -7,

msoBalloonButtonNext = -6,

msoBalloonButtonBack = -5,

msoBalloonButtonNo = -4,

msoBalloonButtonYes = -3,

msoBalloonButtonCancel = -2,

msoBalloonButtonOK = -1,

msoBalloonButtonNull = 0

};

enum DocProperties

{

offPropertyTypeNumber = 1,

offPropertyTypeBoolean = 2,

offPropertyTypeDate = 3,

offPropertyTypeString = 4,

offPropertyTypeFloat = 5

};

enum MsoDocProperties

{

msoPropertyTypeNumber = 1,

msoPropertyTypeBoolean = 2,

msoPropertyTypeDate = 3,

msoPropertyTypeString = 4,

msoPropertyTypeFloat = 5

};

enum MsoAppLanguageID

{

msoLanguageIDInstall = 1,

msoLanguageIDUI = 2,

msoLanguageIDHelp = 3,

msoLanguageIDExeMode = 4,

msoLanguageIDUIPrevious = 5

};

enum MsoFarEastLineBreakLanguageID

{

MsoFarEastLineBreakLanguageJapanese = 1041,

MsoFarEastLineBreakLanguageKorean = 1042,

MsoFarEastLineBreakLanguageSimplifiedChinese = 2052,

MsoFarEastLineBreakLanguageTraditionalChinese = 1028

};

enum MsoFeatureInstall

{

msoFeatureInstallNone = 0,

msoFeatureInstallOnDemand = 1,

msoFeatureInstallOnDemandWithUI = 2

};

※ Re:Excel常用枚举常量列表，对应的数字终于全成查了

mountain315发表评论于2006-4-5 12:54:00 个人主页 | 引用 | 返回 | 删除 | 回复

以下是引用huangshuchun在2006-4-5 12:39:00的发言：

对VBA常量的值可以在打开Word或者Excel后按Alt + F11键调出VBA编辑器,然后再按F2打开对象浏览器，输入常量名称就可以查了

发表评论：

昵称：

密码：

主页：标题：