首先alt+f11,工具引用,勾选microsoft excel 11.0 object library,然后插入模块
Sub op()
Dim app As New Excel.Application
Dim wb As Excel.Workbook
Set wb = app.Workbooks.Open("d:/tt.xls")
MsgBox wb.Sheets("sheet1").Range("c5")
app.Quit
End Sub
子易空间站 - Excel培训专家
温馨提示:答案为网友推荐,仅供参考