|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub Macro1()
- Dim i&, Myr&, Myc%, Arr, j&, n&
- Dim myFs As FileSearch
- Dim myPath$, wb1 As Workbook
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Myr = Sheet1.[a65536].End(xlUp).Row
- Arr = Sheet1.Range("a1:a" & Myr)
- On Error Resume Next
- Set wb1 = ThisWorkbook
- Set myFs = Application.FileSearch
- myPath = ThisWorkbook.Path & "\z"
- With myFs
- .NewSearch
- .LookIn = myPath
- .FileType = msoFileTypeNoteItem
- .Filename = "*.mp3"
- .SearchSubFolders = True
- If .Execute(SortBy:=msoSortByFileName) > 0 Then
- n = .FoundFiles.Count
- For j = 1 To UBound(Arr)
- For i = 1 To n
- If InStr(.FoundFiles(i), Arr(j, 1)) > 0 Then
- ActiveSheet.Hyperlinks.Add Anchor:=Cells(j, 1), Address:= _
- .FoundFiles(i), TextToDisplay:=Arr(j, 1)
- Exit For
- End If
- Next
- Next
- End If
- End With
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|