?? excel.sub
字號:
FPAttributeValueFile
n TypeLibGUID="{00020813-0000-0000-C000-000000000046}"
n TypeLibLCID="0"
n HelpFile="VBAXL10.CHM"
n TypeLibVersion="1.5"
n SubType="COA"
n SubVersion="1"
v enum_ExcelEnum_XlCreator DataType="i"
ExcelConst_xlCreatorCode (1480803660)
""
v CABooleanValueSet DataType="i"
VTRUE (-1)
""
VFALSE (0)
""
v enum_ExcelEnum_XlCellInsertionMode DataType="i"
ExcelConst_xlOverwriteCells (0)
""
ExcelConst_xlInsertDeleteCells (1)
""
ExcelConst_xlInsertEntireRows (2)
""
v enum_ExcelEnum_XlCmdType DataType="i"
ExcelConst_xlCmdCube (1)
""
ExcelConst_xlCmdSql (2)
""
ExcelConst_xlCmdTable (3)
""
ExcelConst_xlCmdDefault (4)
""
ExcelConst_xlCmdList (5)
""
v enum_ExcelEnum_XlQueryType DataType="i"
ExcelConst_xlODBCQuery (1)
""
ExcelConst_xlDAORecordset (2)
""
ExcelConst_xlWebQuery (4)
""
ExcelConst_xlOLEDBQuery (5)
""
ExcelConst_xlTextImport (6)
""
ExcelConst_xlADORecordset (7)
""
v enum_ExcelEnum_XlTextParsingType DataType="i"
ExcelConst_xlDelimited (1)
""
ExcelConst_xlFixedWidth (2)
""
v enum_ExcelEnum_XlTextQualifier DataType="i"
ExcelConst_xlTextQualifierDoubleQuote (1)
""
ExcelConst_xlTextQualifierNone (-4142)
""
ExcelConst_xlTextQualifierSingleQuote (2)
""
v enum_ExcelEnum_XlWebSelectionType DataType="i"
ExcelConst_xlEntirePage (1)
""
ExcelConst_xlAllTables (2)
""
ExcelConst_xlSpecifiedTables (3)
""
v enum_ExcelEnum_XlWebFormatting DataType="i"
ExcelConst_xlWebFormattingAll (1)
""
ExcelConst_xlWebFormattingRTF (2)
""
ExcelConst_xlWebFormattingNone (3)
""
v enum_ExcelEnum_XlRobustConnect DataType="i"
ExcelConst_xlAsRequired (0)
""
ExcelConst_xlAlways (1)
""
ExcelConst_xlNever (2)
""
v enum_ExcelEnum_XlTextVisualLayoutType DataType="i"
ExcelConst_xlTextVisualLTR (1)
""
ExcelConst_xlTextVisualRTL (2)
""
v enum_ExcelEnum_XlCalculation DataType="i"
ExcelConst_xlCalculationAutomatic (-4105)
""
ExcelConst_xlCalculationManual (-4135)
""
ExcelConst_xlCalculationSemiautomatic (2)
""
v enum_ExcelEnum_XlCommandUnderlines DataType="i"
ExcelConst_xlCommandUnderlinesAutomatic (-4105)
""
ExcelConst_xlCommandUnderlinesOff (-4146)
""
ExcelConst_xlCommandUnderlinesOn (1)
""
v enum_ExcelEnum_XlCutCopyMode DataType="i"
ExcelConst_xlCopy (1)
""
ExcelConst_xlCut (2)
""
v enum_ExcelEnum_XlReferenceStyle DataType="i"
ExcelConst_xlA1 (1)
""
ExcelConst_xlR1C1 (-4150)
""
v enum_ExcelEnum_XlWindowState DataType="i"
ExcelConst_xlMaximized (-4137)
""
ExcelConst_xlMinimized (-4140)
""
ExcelConst_xlNormal (-4143)
""
v enum_ExcelEnum_XlMailSystem DataType="i"
ExcelConst_xlMAPI (1)
""
ExcelConst_xlNoMailSystem (0)
""
ExcelConst_xlPowerTalk (2)
""
v enum_ExcelEnum_XlEnableCancelKey DataType="i"
ExcelConst_xlDisabled (0)
""
ExcelConst_xlErrorHandler (2)
""
ExcelConst_xlInterrupt (1)
""
v enum_ExcelEnum_XlDirection DataType="i"
ExcelConst_xlDown (-4121)
""
ExcelConst_xlToLeft (-4159)
""
ExcelConst_xlToRight (-4161)
""
ExcelConst_xlUp (-4162)
""
v enum_ExcelEnum_XlMousePointer DataType="i"
ExcelConst_xlIBeam (3)
""
ExcelConst_xlDefault (-4143)
""
ExcelConst_xlNorthwestArrow (1)
""
ExcelConst_xlWait (2)
""
v enum_ExcelEnum_XlCommentDisplayMode DataType="i"
ExcelConst_xlNoIndicator (0)
""
ExcelConst_xlCommentIndicatorOnly (-1)
""
ExcelConst_xlCommentAndIndicator (1)
""
v enum_ExcelEnum_XlFileFormat DataType="i"
ExcelConst_xlAddIn (18)
""
ExcelConst_xlCSV (6)
""
ExcelConst_xlCSVMac (22)
""
ExcelConst_xlCSVMSDOS (24)
""
ExcelConst_xlCSVWindows (23)
""
ExcelConst_xlDBF2 (7)
""
ExcelConst_xlDBF3 (8)
""
ExcelConst_xlDBF4 (11)
""
ExcelConst_xlDIF (9)
""
ExcelConst_xlExcel2 (16)
""
ExcelConst_xlExcel2FarEast (27)
""
ExcelConst_xlExcel3 (29)
""
ExcelConst_xlExcel4 (33)
""
ExcelConst_xlExcel5 (39)
""
ExcelConst_xlExcel7 (39)
""
ExcelConst_xlExcel9795 (43)
""
ExcelConst_xlExcel4Workbook (35)
""
ExcelConst_xlIntlAddIn (26)
""
ExcelConst_xlIntlMacro (25)
""
ExcelConst_xlWorkbookNormal (-4143)
""
ExcelConst_xlSYLK (2)
""
ExcelConst_xlTemplate (17)
""
ExcelConst_xlCurrentPlatformText (-4158)
""
ExcelConst_xlTextMac (19)
""
ExcelConst_xlTextMSDOS (21)
""
ExcelConst_xlTextPrinter (36)
""
ExcelConst_xlTextWindows (20)
""
ExcelConst_xlWJ2WD1 (14)
""
ExcelConst_xlWK1 (5)
""
ExcelConst_xlWK1ALL (31)
""
ExcelConst_xlWK1FMT (30)
""
ExcelConst_xlWK3 (15)
""
ExcelConst_xlWK4 (38)
""
ExcelConst_xlWK3FM3 (32)
""
ExcelConst_xlWKS (4)
""
ExcelConst_xlWorks2FarEast (28)
""
ExcelConst_xlWQ1 (34)
""
ExcelConst_xlWJ3 (40)
""
ExcelConst_xlWJ3FJ3 (41)
""
ExcelConst_xlUnicodeText (42)
""
ExcelConst_xlHtml (44)
""
ExcelConst_xlWebArchive (45)
""
ExcelConst_xlXMLSpreadsheet (46)
""
v enum_ExcelEnum_MsoFeatureInstall DataType="i"
ExcelConst_msoFeatureInstallNone (0)
""
ExcelConst_msoFeatureInstallOnDemand (1)
""
ExcelConst_msoFeatureInstallOnDemandWithUI (2)
""
v enum_ExcelEnum_XlCalculationState DataType="i"
ExcelConst_xlDone (0)
""
ExcelConst_xlCalculating (1)
""
ExcelConst_xlPending (2)
""
v enum_ExcelEnum_XlCalculationInterruptKey DataType="i"
ExcelConst_xlNoKey (0)
""
ExcelConst_xlEscKey (1)
""
ExcelConst_xlAnyKey (2)
""
v enum_ExcelEnum_MsoAutomationSecurity DataType="i"
ExcelConst_msoAutomationSecurityLow (1)
""
ExcelConst_msoAutomationSecurityByUI (2)
""
ExcelConst_msoAutomationSecurityForceDisable (3)
""
v enum_ExcelEnum_XlDisplayBlanksAs DataType="i"
ExcelConst_xlInterpolated (3)
""
ExcelConst_xlNotPlotted (1)
""
ExcelConst_xlZero (2)
""
v enum_ExcelEnum_XlRowCol DataType="i"
ExcelConst_xlColumns (2)
""
ExcelConst_xlRows (1)
""
v enum_ExcelEnum_XlSheetVisibility DataType="i"
ExcelConst_xlSheetVisible (-1)
""
ExcelConst_xlSheetHidden (0)
""
ExcelConst_xlSheetVeryHidden (2)
""
v enum_ExcelEnum_XlChartType DataType="i"
ExcelConst_xlColumnClustered (51)
""
ExcelConst_xlColumnStacked (52)
""
ExcelConst_xlColumnStacked100 (53)
""
ExcelConst_xl3DColumnClustered (54)
""
ExcelConst_xl3DColumnStacked (55)
""
ExcelConst_xl3DColumnStacked100 (56)
""
ExcelConst_xlBarClustered (57)
""
ExcelConst_xlBarStacked (58)
""
ExcelConst_xlBarStacked100 (59)
""
ExcelConst_xl3DBarClustered (60)
""
ExcelConst_xl3DBarStacked (61)
""
ExcelConst_xl3DBarStacked100 (62)
""
ExcelConst_xlLineStacked (63)
""
ExcelConst_xlLineStacked100 (64)
""
ExcelConst_xlLineMarkers (65)
""
ExcelConst_xlLineMarkersStacked (66)
""
ExcelConst_xlLineMarkersStacked100 (67)
""
ExcelConst_xlPieOfPie (68)
""
ExcelConst_xlPieExploded (69)
""
ExcelConst_xl3DPieExploded (70)
""
ExcelConst_xlBarOfPie (71)
""
ExcelConst_xlXYScatterSmooth (72)
""
ExcelConst_xlXYScatterSmoothNoMarkers (73)
""
ExcelConst_xlXYScatterLines (74)
""
ExcelConst_xlXYScatterLinesNoMarkers (75)
""
ExcelConst_xlAreaStacked (76)
""
ExcelConst_xlAreaStacked100 (77)
""
ExcelConst_xl3DAreaStacked (78)
""
ExcelConst_xl3DAreaStacked100 (79)
""
ExcelConst_xlDoughnutExploded (80)
""
ExcelConst_xlRadarMarkers (81)
""
ExcelConst_xlRadarFilled (82)
""
ExcelConst_xlSurface (83)
""
ExcelConst_xlSurfaceWireframe (84)
""
ExcelConst_xlSurfaceTopView (85)
""
ExcelConst_xlSurfaceTopViewWireframe (86)
""
ExcelConst_xlBubble (15)
""
ExcelConst_xlBubble3DEffect (87)
""
ExcelConst_xlStockHLC (88)
""
ExcelConst_xlStockOHLC (89)
""
ExcelConst_xlStockVHLC (90)
""
ExcelConst_xlStockVOHLC (91)
""
ExcelConst_xlCylinderColClustered (92)
""
ExcelConst_xlCylinderColStacked (93)
""
ExcelConst_xlCylinderColStacked100 (94)
""
ExcelConst_xlCylinderBarClustered (95)
""
ExcelConst_xlCylinderBarStacked (96)
""
ExcelConst_xlCylinderBarStacked100 (97)
""
ExcelConst_xlCylinderCol (98)
""
ExcelConst_xlConeColClustered (99)
""
ExcelConst_xlConeColStacked (100)
""
ExcelConst_xlConeColStacked100 (101)
""
ExcelConst_xlConeBarClustered (102)
""
ExcelConst_xlConeBarStacked (103)
""
ExcelConst_xlConeBarStacked100 (104)
""
ExcelConst_xlConeCol (105)
""
ExcelConst_xlPyramidColClustered (106)
""
ExcelConst_xlPyramidColStacked (107)
""
ExcelConst_xlPyramidColStacked100 (108)
""
ExcelConst_xlPyramidBarClustered (109)
""
ExcelConst_xlPyramidBarStacked (110)
""
ExcelConst_xlPyramidBarStacked100 (111)
""
ExcelConst_xlPyramidCol (112)
""
ExcelConst_xl3DColumn (-4100)
""
ExcelConst_xlLine (4)
""
ExcelConst_xl3DLine (-4101)
""
ExcelConst_xl3DPie (-4102)
""
ExcelConst_xlPie (5)
""
ExcelConst_xlXYScatter (-4169)
""
ExcelConst_xl3DArea (-4098)
""
ExcelConst_xlArea (1)
""
ExcelConst_xlDoughnut (-4120)
""
ExcelConst_xlRadar (-4151)
""
v enum_ExcelEnum_XlBarShape DataType="i"
ExcelConst_xlBox (0)
""
ExcelConst_xlPyramidToPoint (1)
""
ExcelConst_xlPyramidToMax (2)
""
ExcelConst_xlCylinder (3)
""
ExcelConst_xlConeToPoint (4)
""
ExcelConst_xlConeToMax (5)
""
v enum_ExcelEnum_XlSheetType DataType="i"
ExcelConst_xlChart (-4109)
""
ExcelConst_xlDialogSheet (-4116)
""
ExcelConst_xlExcel4IntlMacroSheet (4)
""
ExcelConst_xlExcel4MacroSheet (3)
""
ExcelConst_xlWorksheet (-4167)
""
v enum_ExcelEnum_XlConsolidationFunction DataType="i"
ExcelConst_xlAverage (-4106)
""
ExcelConst_xlCount (-4112)
""
ExcelConst_xlCountNums (-4113)
""
ExcelConst_xlMax (-4136)
""
ExcelConst_xlMin (-4139)
""
ExcelConst_xlProduct (-4149)
""
ExcelConst_xlStDev (-4155)
""
ExcelConst_xlStDevP (-4156)
""
ExcelConst_xlSum (-4157)
""
ExcelConst_xlVar (-4164)
""
ExcelConst_xlVarP (-4165)
""
ExcelConst_xlUnknown (1000)
""
v enum_ExcelEnum_XlEnableSelection DataType="i"
ExcelConst_xlNoRestrictions (0)
""
ExcelConst_xlUnlockedCells (1)
""
ExcelConst_xlNoSelection (-4142)
""
v enum_ExcelEnum_XlDisplayDrawingObjects DataType="i"
ExcelConst_xlDisplayShapes (-4104)
""
ExcelConst_xlHide (3)
""
ExcelConst_xlPlaceholders (2)
""
v enum_ExcelEnum_XlUpdateLinks DataType="i"
ExcelConst_xlUpdateLinksUserSetting (1)
""
ExcelConst_xlUpdateLinksNever (2)
""
ExcelConst_xlUpdateLinksAlways (3)
""
v enum_ExcelEnum_XlSaveConflictResolution DataType="i"
ExcelConst_xlLocalSessionChanges (2)
""
ExcelConst_xlOtherSessionChanges (3)
""
ExcelConst_xlUserResolution (1)
""
v enum_ExcelEnum_MsoTriState DataType="i"
ExcelConst_msoTrue (-1)
""
ExcelConst_msoFalse (0)
""
ExcelConst_msoCTrue (1)
""
ExcelConst_msoTriStateToggle (-3)
""
ExcelConst_msoTriStateMixed (-2)
""
v enum_ExcelEnum_MsoCalloutAngleType DataType="i"
ExcelConst_msoCalloutAngleMixed (-2)
""
ExcelConst_msoCalloutAngleAutomatic (1)
""
ExcelConst_msoCalloutAngle30 (2)
""
ExcelConst_msoCalloutAngle45 (3)
""
ExcelConst_msoCalloutAngle60 (4)
""
ExcelConst_msoCalloutAngle90 (5)
""
v enum_ExcelEnum_MsoCalloutDropType DataType="i"
ExcelConst_msoCalloutDropMixed (-2)
""
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -