Public Sub dierti()
Dim mypath As String
mypath = ActiveWorkbook.Path
Set wb1 = Workbooks("第12集练习题")
Set wb2 = Workbooks.Open(mypath & "\" & "A.xls")
wb1.Sheets(2).Cells.ClearContents
wb2.Sheets(1).Select
wb2.Sheets(1).UsedRange.Copy wb1.Sheets(2).Range("a1")
For i = 2 To wb2.Sheets.Count
j = Sheets(i).UsedRange.Rows.Count
k = Sheets(i).UsedRange.Columns.Count
Sheets(i).UsedRange.Offset(1, 0).Resize(j - 1, k).Copy wb1.Sheets(2).Range("a65536").End(xlUp).Offset(1, 0)
Next i