6,210
社区成员
发帖
与我相关
我的任务
分享
Public Sub test()
Dim oSheet As Worksheet
Dim i As Integer
Set oSheet = Sheet1
For i = 1 To oSheet.UsedRange.Rows.Count
oSheet.Cells(i, 3).Formula = "='C:\TEMP\access\[" & oSheet.Cells(i, 1) & ".xls]Sheet1'!$L$7" '改为你自己的目录 -- liuyann
Next i
End Sub
Public Sub test()
Dim oSheet As Worksheet
Dim i As Integer
Set oSheet = Sheet1
For i = 1 To oSheet.UsedRange.Rows.Count
oSheet.Cells(i, 3).Formula = "='C:\TEMP\access\[" & oSheet.Cells(i, 1) & ".xls]Sheet1'!$L$7" '改为你自己的目录 -- liuyann
Next i
End Sub
=INDIRECT("["&A1&".xls]Sheet1!$L$10")
=INDIRECT("["&A1&".xls]Sheet1!$L$10")