宏将数据从一个excel传输到另一个excel。

Sub TransferData()
    Dim sourceWorkbook As Workbook
    Dim targetWorkbook As Workbook
    Dim sourceWorksheet As Worksheet
    Dim targetWorksheet As Worksheet
    
    ' 打开源工作簿
    Set sourceWorkbook = Workbooks.Open("源工作簿路径")
    ' 打开目标工作簿
    Set targetWorkbook = Workbooks.Open("目标工作簿路径")
    
    ' 指定源工作表和目标工作表
    Set sourceWorksheet = sourceWorkbook.Worksheets("源工作表名称")
    Set targetWorksheet = targetWorkbook.Worksheets("目标工作表名称")
    
    ' 复制数据
    sourceWorksheet.UsedRange.Copy targetWorksheet.Range("A1")
    
    ' 关闭工作簿并保存更改
    sourceWorkbook.Close SaveChanges:=False
    targetWorkbook.Close SaveChanges:=True
    
    ' 释放对象
    Set sourceWorksheet = Nothing
    Set targetWorksheet = Nothing
    Set sourceWorkbook = Nothing
    Set targetWorkbook = Nothing
    
    MsgBox "数据传输完成！"
End Sub