|
发表于 2017-8-29 16:52
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- Dim Mypath$, myname$, wk As Workbook
- Mypath = ThisWorkbook.Path & ""
- myname = Dir(Mypath & "*.xlsx")
- i = 1
- Do While myname <> ""
- If InStr(myname, "超链接") = 0 Then
- i = i + 1
- ActiveSheet.Hyperlinks.Add Anchor:=Cells(i, 1), Address:=Mypath & myname, _
- SubAddress:="sheet1!A1", TextToDisplay:=myname
- End If
- myname = Dir
- Loop
- End Sub
复制代码 |
评分
-
查看全部评分
|