首次运行成功,工作簿工作表的activate对象值也正常,再次运行就报错
Option Explicit
Dim xlapp As Excel.Application 'Excel对象
Dim xlbook As Excel.Workbook '工作簿
Dim xlsheet As Excel.Worksheet '工作表
Private Sub Command9_Click()
'将新增记录导出到总表
Application.DisplayAlerts = False
Dim i As Integer, i1 As Integer, x As Integer, y As Integer
Dim iReco As Integer
Dim v As String, s As String, strsql As String
Dim stTable As String
Set xlapp = CreateObject("excel.application")
xlapp.Visible = True
v = Application.GetOpenFilename(FileFilter:="Excel文件 (*.xls; *.xlsx),*.xls; *.xlsx,所有文件(*.*),*.*", Title:="导出到按需模板", MultiSelect:=False)
If InStr(v, ".xls") < 1 Then
MsgBox ("未选择正确的exl文件")
Set xlapp = Nothing
Exit Sub
End If
Set xlbook = xlapp.Workbooks.Open(v)
xlbook.Activate
MsgBox xlbook.Name & ActiveWorkbook.Name
Set xlsheet = xlbook.Worksheets(2)
xlbook.Activate
i = xlsheet.UsedRange.Rows.Count
MsgBox i
xlsheet.Activate
If i > 1 Then
MsgBox ActiveSheet.Name
xlsheet.Range("A2").Select
Debug.Print Selection
xlsheet.Range(Selection, Selection.End(xlDown)).Select
xlsheet.Range(Selection, Selection.End(xlToRight)).Select
Selection.ClearContents
End If
xlbook.Save
xlbook.Close (True)
' Set xlsheet = Nothing
' Set xlbook = Nothing
xlapp.Quit
' Set xlapp = Nothing
Application.DisplayAlerts = True
End Sub