Sub TEST()
Workbooks.Open "C:\新文件.xlsx" '打开被粘贴的文件
ThisWorkbook.Sheets(1).Range("A1:B10").Copy '复制源
ActiveWorkbook.Sheets(2).Activate
Range("A1").Select '激活被粘贴的起始单元
ActiveSheet.Paste
ActiveWorkbook.Close True
End Sub
Sub TEST()
Workbooks.Open "C:\新文件.xlsx" '打开被粘贴的文件
ThisWorkbook.Sheets(1).Range("A1:B10").Copy '复制源
ActiveWorkbook.Sheets(2).Activate
Range("A1").Select '激活被粘贴的起始单元
ActiveSheet.Paste
ActiveWorkbook.Close True
End Sub