|
[试题批量导入模板]这个电子表格关闭不了
以下是部分代码,全部代码在附件中
- Dim ZJStr() As String '章节列表
- Dim ZJId() As String
-
- Dim FileStr As String
- FileStr = AppStr & "试题批量导入模板.xls"
- If FileStr = "" Then
- Exit Sub
- End If
-
-
- Label1.Caption = "正在分析章节信息,请稍后!"
-
- Dim Sql As String
- Dim MsgTxt As String
- Dim Rs_Zj As ADODB.Recordset
- Dim Rs As ADODB.Recordset
-
-
- Sql = "select * from zjinfo "
- Set Rs_Zj = ExecuteSQL(Sql, MsgTxt)
-
- If InStr(MsgTxt, "错误") Then
- MsgBox MsgTxt
- Exit Sub
- End If
-
- ReDim ZJStr(0)
- ReDim ZJId(0)
- If Rs_Zj.RecordCount > 0 Then '========================获取章节信息 如果有
-
- For i = 1 To Rs_Zj.RecordCount
- ReDim Preserve ZJStr(i)
- ReDim Preserve ZJId(i)
-
- ZJStr(i) = Rs_Zj.Fields("zjname") & ""
- ZJId(i) = Rs_Zj.Fields("zjid") & ""
- Rs_Zj.MoveNext
- Next i
-
-
- End If
-
-
- Sql = "select * from tminfo"
- Set Rs = ExecuteSQL(Sql, MsgTxt)
- If InStr(MsgTxt, "错误") Then
- MsgBox MsgTxt
- Exit Sub
- End If
-
-
-
- Dim NewApp
- Dim NewSheet
- Dim NewBook
-
- Set NewApp = New Excel.Application
- Set NewBook = NewApp.Workbooks.Open(FileStr, , , , "")
- '第一位为路径,第五位为密码
- Set NewSheet = NewBook.Worksheets(1)
-
- For i = 2 To NewSheet.Cells.Count
复制代码
|
|