vba操作两个excel(在一个EXCEL中引用另一个EXCEL的值)

来源:互联网 发布:淘宝商品销量统计 编辑:程序博客网 时间:2024/06/05 03:35
Dim aworkbook As Excel.Workbook

Dim strpath As String

Dim ss As String

strpath = Excel.ActiveWorkbook.Path

Set aworkbook = GetObject(strpath & "\\test.xls")


ss = aworkbook.Sheets(1).Range("A1").Value
原创粉丝点击