Sub xiugai()
Application.ScreenUpdating = False
Dim Ph, Myfile
Ph = "C:\Users\Administrator\Downloads\需解决" '文档存放位置
Myfile = Dir(Ph & "\*.*")
Do While Myfile <> "" And Myfile <> ThisWorkbook.Name
Set wb = Workbooks.Open(Ph & "\" & Myfile)
With wb
.Sheets("表三甲").[e7:e17].Copy Sheets("表三甲").[k7:k17]
End With
wb.Close True
Myfile = Dir
Loop
Application.ScreenUpdating = true
Sub xiugai()
Application.ScreenUpdating = False
Dim Ph, Myfile
Ph = "C:\Users\Administrator\Downloads\需解决" '文档存放位置
Myfile = Dir(Ph & "\*.*")
Do While Myfile <> "" And Myfile <> ThisWorkbook.Name
Set wb = Workbooks.Open(Ph & "\" & Myfile)
With wb
.Sheets("表三甲").[e7:e17].Copy Sheets("表三甲").[k7:k17]
End With
wb.Close True
Myfile = Dir
Loop
Application.ScreenUpdating = true