excel.sub

这是我编写的深圳地铁S335型司机控制器的检测程序

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)
  ""