|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 魂断蓝桥 于 2018-5-2 15:21 编辑
Private Sub CommandButton1_Click()
Dim myfile$, i%
'myfile = Application.GetOpenFilename("Excel文件,*.xls")
myfile = "\\192.168.1.199\\p\\求助.xls"
If myfile = "False" Then Exit Sub
With Me.VSFlexGrid1
.Clear
.LoadGrid myfile, flexFileExcel, 0
.ColWidth(0) = 800
For i = 1 To .Cols - 1
.TextMatrix(0, i) = .TextMatrix(1, i)
Next
.TextMatrix(0, 0) = "序号"
.RemoveItem (1)
For i = 1 To .Rows - 1
.TextMatrix(i, 0) = i
Next
.Font.Name = "微软雅黑"
.Font.Size = 9
.GridColor = vbBlack
.ColAlignment(-1) = 4
End With
End Sub
Private Sub CommandButton2_Click()
Dim myfile$, i%
myfile = Application.GetSaveAsFilename(fileFilter:="*.xls, *.xls")
If myfile = "False" Then Exit Sub
Me.VSFlexGrid1.SaveGrid myfile, flexFileExcel, 1
End Sub
|
|