Sub copyall() For i = 1 To 5 '把这个数字改成你的文件总数 Set excel_Book = Workbooks.Open("地址" & i & ".xls") '地址写作"E:\xxx\xxx\",把数字空出来,保留英文双引号。如果是xlsx请在此处 ↑ 后缀上更改 Set excel_Sheet = excel_Book.Worksheets("Sheet1") excel_Sheet.Range("A1:D10").Copy ThisWorkbook.Worksheets("Sheet1").Range("A" & 1 + (i - 1) * 10).PasteSpecial excel_Book.Close False Next Set excel_Sheet = Nothing Set excel_Book = Nothing End Sub