|
Sub Ck()
Dim fso As New Scripting.FileSystemObject
Dim sfolder As Folder, i As Integer
Dim sFileName As String
Dim j As Long, wjj
Sheet1.Cells.Clear
i = 1
On Error Resume Next
For Each sfolder In fso.getfolder(ThisWorkbook.Path).SubFolders
wjj = sfolder.Name
Spath = ThisWorkbook.Path & "\" & wjj & "\"
With Sheet1
.Cells(Application.WorksheetFunction.CountA(Sheet1.Range("b:b")) + 1, 1) = wjj '& ":"可以加冒号等内容
.Cells(Application.WorksheetFunction.CountA(Sheet1.Range("b:b")) + 1, 1).Font.Bold = True
j = 2
sFileName = Dir(Spath, 0) '取得文件名
Do While Len(sFileName) > 0
'.Cells(j + 1, 2) = sFileName'取得的文件名没有链接
.Cells(i, j).Select '取得的文件名有链接
ActiveSheet.Hyperlinks.Add anchor:=Selection, Address:=Spath & sFileName, _
TextToDisplay:=sFileName
sFileName = Dir()
j = j + 1
Loop
End With
i = i + 1
Next
Set fso = Nothing
End Sub |
|