📄 mhikitorisaki.frm
字号:
VERSION 5.00
Object = "{C0A63B80-4B21-11D3-BD95-D426EF2C7949}#1.0#0"; "Vsflex7L.ocx"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Begin VB.Form frmTantoM
BackColor = &H00FFC0C0&
Caption = "堷庢愭儅僗僞"
ClientHeight = 8115
ClientLeft = 3360
ClientTop = 2565
ClientWidth = 8100
ForeColor = &H00FFFFFF&
Icon = "MHIKITORISAKI.frx":0000
LinkTopic = "Form3"
LockControls = -1 'True
ScaleHeight = 8115
ScaleWidth = 8100
Begin MSComDlg.CommonDialog CommonDialog1
Left = 5160
Top = 2760
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.TextBox txtTel
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1200
TabIndex = 16
Top = 3240
Width = 2655
End
Begin VB.ComboBox txtCouse
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 1200
TabIndex = 13
Top = 2040
Width = 1815
End
Begin VB.TextBox txtAdd
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1200
TabIndex = 12
Top = 2640
Width = 3375
End
Begin VB.TextBox txtName
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1200
TabIndex = 10
Top = 1440
Width = 2535
End
Begin VB.TextBox txtCode
BackColor = &H80000004&
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1200
TabIndex = 8
Top = 840
Width = 1695
End
Begin VB.CommandButton Command1
BackColor = &H00FF8080&
DisabledPicture = "MHIKITORISAKI.frx":08CA
DownPicture = "MHIKITORISAKI.frx":508C
Height = 1215
Left = 4800
MaskColor = &H00FF8080&
Picture = "MHIKITORISAKI.frx":984E
Style = 1 '皋滋ǒ附
TabIndex = 6
Top = 0
Width = 975
End
Begin VB.CommandButton Command2
BackColor = &H00FF8080&
Height = 1215
Left = 5880
MaskColor = &H00FF8080&
Picture = "MHIKITORISAKI.frx":E010
Style = 1 '皋滋ǒ附
TabIndex = 5
Top = 0
Width = 975
End
Begin VB.CommandButton Command3
BackColor = &H00FF8080&
Height = 1215
Left = 6960
MaskColor = &H00FF8080&
Picture = "MHIKITORISAKI.frx":1244A
Style = 1 '皋滋ǒ附
TabIndex = 4
Top = 0
Width = 975
End
Begin VB.CommandButton Command4
BackColor = &H00FF8080&
Height = 1215
Left = 4800
MaskColor = &H00FF8080&
Picture = "MHIKITORISAKI.frx":1677C
Style = 1 '皋滋ǒ附
TabIndex = 3
Top = 1320
Width = 975
End
Begin VB.CommandButton Command5
BackColor = &H00FF8080&
Height = 1215
Left = 5880
Picture = "MHIKITORISAKI.frx":1AAAE
Style = 1 '皋滋ǒ附
TabIndex = 2
Top = 1320
Width = 975
End
Begin VB.CommandButton Command6
BackColor = &H00FF8080&
Height = 1215
Left = 6960
MaskColor = &H00FF8080&
Picture = "MHIKITORISAKI.frx":1F044
Style = 1 '皋滋ǒ附
TabIndex = 1
Top = 1320
Width = 975
End
Begin VSFlex7LCtl.VSFlexGrid fg
Height = 3975
Left = 0
TabIndex = 0
Top = 4080
Width = 8055
_cx = 14208
_cy = 7011
_ConvInfo = 1
Appearance = 1
BorderStyle = 1
Enabled = -1 'True
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "俵俽 俹僑僔僢僋"
Size = 9
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
MousePointer = 0
BackColor = 16777215
ForeColor = -2147483640
BackColorFixed = 9824949
ForeColorFixed = -2147483630
BackColorSel = -2147483635
ForeColorSel = -2147483634
BackColorBkg = 16761024
BackColorAlternate= 16777215
GridColor = 9890219
GridColorFixed = 12632256
TreeColor = -2147483632
FloodColor = 192
SheetBorder = -2147483642
FocusRect = 1
HighLight = 1
AllowSelection = -1 'True
AllowBigSelection= -1 'True
AllowUserResizing= 0
SelectionMode = 0
GridLines = 2
GridLinesFixed = 1
GridLineWidth = 1
Rows = 50
Cols = 5
FixedRows = 1
FixedCols = 0
RowHeightMin = 0
RowHeightMax = 0
ColWidthMin = 0
ColWidthMax = 0
ExtendLastCol = 0 'False
FormatString = $"MHIKITORISAKI.frx":2315E
ScrollTrack = 0 'False
ScrollBars = 3
ScrollTips = 0 'False
MergeCells = 0
MergeCompare = 0
AutoResize = -1 'True
AutoSizeMode = 0
AutoSearch = 0
AutoSearchDelay = 2
MultiTotals = -1 'True
SubtotalPosition= 1
OutlineBar = 0
OutlineCol = 0
Ellipsis = 0
ExplorerBar = 0
PicturesOver = 0 'False
FillStyle = 0
RightToLeft = 0 'False
PictureType = 0
TabBehavior = 0
OwnerDraw = 0
Editable = 0
ShowComboButton = 1
WordWrap = 0 'False
TextStyle = 0
TextStyleFixed = 0
OleDragMode = 0
OleDropMode = 0
ComboSearch = 3
AutoSizeMouse = -1 'True
FrozenRows = 0
FrozenCols = 0
AllowUserFreezing= 0
BackColorFrozen = 0
ForeColorFrozen = 0
WallPaperAlignment= 9
End
Begin VB.Label Label5
BackStyle = 0 '摟柧
Caption = "揹榖斣崋"
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 0
TabIndex = 15
Top = 3360
Width = 1215
End
Begin VB.Label Label4
BackStyle = 0 '摟柧
Caption = "廧強"
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 14
Top = 2760
Width = 735
End
Begin VB.Label Label3
BackStyle = 0 '摟柧
Caption = "僐乕僗"
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 11
Top = 2160
Width = 855
End
Begin VB.Label Label2
BackStyle = 0 '摟柧
Caption = "柤徧"
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 9
Top = 1560
Width = 735
End
Begin VB.Label Label1
BackStyle = 0 '摟柧
Caption = "僐乕僪"
BeginProperty Font
Name = "俵俽 俹僑僔僢僋"
Size = 14.25
Charset = 128
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 7
Top = 960
Width = 855
End
Begin VB.Image Image1
Height = 735
Left = 0
Picture = "MHIKITORISAKI.frx":231FA
Top = 0
Width = 2490
End
Begin VB.Menu file1
Caption = "filefile"
Visible = 0 'False
Begin VB.Menu file1del
Caption = "Delete"
End
End
End
Attribute VB_Name = "frmTantoM"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
On Error GoTo handler
Dim filename As String
CommonDialog1.Filter = "Microsoft Excel(*.xls)|*.xls"
CommonDialog1.ShowSave
filename = CommonDialog1.filename
Dim xlApp As excel.Application
Dim xlBook As excel.Workbook
Dim xlsheet As excel.Worksheet
Set xlApp = New excel.Application
Set xlBook = xlApp.Workbooks.Add
Set xlsheet = xlBook.Worksheets(1)
xlsheet.Activate
xlApp.Visible = False
' With xlsheet
' .Range("A4:A4") = "10001"
' .Cells(5, 2) = "10002"
' End With
Dim appRow As Long
Dim appCol As Long
Dim FGRow As Long
Dim FGCol As Long
FGRow = fg.Rows
FGCol = fg.Cols
Dim i As Integer
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -