Sub test()
Dim wk1, wk2, i
Application.ScreenUpdating = False
Application.Calculation = xlManual
Call test2
Set wk2 = ThisWorkbook
Set wk1 = Workbooks.Open(wk2.Path & "\导成绩单.xls")
For i = 2 To 7
wk1.Sheets(i).Range("a1").CurrentRegion.Copy wk2.Sheets(i).Range("a1")
Next i
Call test2
' Application.Calculation = xlAutomatic
End Sub
Sub test2()
On Error Resume Next
Workbooks("导成绩单.xls").Close False
On Error GoTo 0
End Sub