|
楼主 |
发表于 2017-8-10 14:05
|
显示全部楼层
本帖最后由 lzqlaj 于 2017-8-10 14:06 编辑
- Private Sub Form_Load()
- Dim xlApp As Excel.Application
- Dim xlbook As Excel.Workbook
- Dim xlsheet As Excel.Worksheet
- On Error Resume Next
- Set xlApp = GetObject(, "Excel.Application")
- If IsFileExists(App.Path & "\三小成绩统计2017.xls") = True Then
- Set xlApp = GetObject(, "Excel.Application")
- If Err.Number <> 0 Then
- Set ObjExcel = CreateObject("Excel.Application")
- ObjExcel.Workbooks.Open App.Path & "\三小成绩统计2017.xls"
- ObjExcel.Visible = True
- Set ObjExcel = Nothing
- Err.Clear
- End If
- Else
- Set xlApp = CreateObject("excel.application")
- Set xlbook = xlApp.Workbooks.Add
- xlApp.Visible = True
- xlbook.Sheets(1).Name = "录入"
- xlbook.Sheets(1).Range("a1") = "序号"
- xlbook.Sheets(1).Range("b1") = "班级"
- xlbook.Sheets(1).Range("c1") = "分数"
- xlbook.SaveAs App.Path & "\三小成绩统计2017.xls"
- xlbook.Sheets(1).Range("A2").FormulaR1C1 = "=IF(RC[2]<>"""",ROW()-1,"""")"
- xlbook.Sheets(1).Range("A2").AutoFill Destination:=Range("A2:A602"), Type:=xlFillDefault
- End If
- End Sub
- Function IsFileExists(ByVal strFileName As String) As Boolean
- Dim objFileSystem As Object
- Set objFileSystem = CreateObject("Scripting.FileSystemObject")
- If objFileSystem.fileExists(strFileName) = True Then
- IsFileExists = True
- Else
- IsFileExists = False
- End If
- End Function
|
评分
-
2
查看全部评分
-
|