Excelvba从另一个工作簿取值

Private Sub getValue_Click()

Dim MyWorkbook As Workbook
Set MyWorkbook = Application.Workbooks.Open("C:UsersjiangwenwenDesktopVBAテストテスト２.xlsx")

ThisWorkbook.Sheets("Sheet1").Range("A1").value = MyWorkbook.Sheets("Sheet1").Range("C7").value
MsgBox (MyWorkbook.Sheets("Sheet1").Range("C7").value)

End Sub
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/jiangwenwen1/p/10294566.html