excel VBA中怎样引用外部单元格
excel VBA中怎样引用外部单元格
日期：2012-09-18 11:59:33 人气：1
Sub test1()
Dim fPath, fName, fl As String
Dim ws As Worksheet
Set ws = Application.ThisWorkbook.Worksheets("sheet1")
fPath = Application.ThisWorkbook.Path & "\"
fName = "Test2.xlsm"
Workbooks.Open fPath & fName