Sub 当前文件夹之文件目录()
Dim myrow As Integer
Dim MyExcelFileName As String
myrow = 1
MyExcelFileName = Dir(ThisWorkbook.Path & "\*.*")
Do While MyExcelFileName <> ""
Cells(myrow, 1) = MyExcelFileName
Cells(myrow, 1).Hyperlinks.Add Anchor:=Cells(myrow, 1), Address:=Cells(myrow, 1), TextToDisplay:=MyExcelFileName
MyExcelFileName = Dir()
myrow = myrow + 1
Loop
End Sub
Sub 当前文件夹之文件目录()
Dim myrow As Integer
Dim MyExcelFileName As String
myrow = 1
MyExcelFileName = Dir(ThisWorkbook.Path & "\*.*")
Do While MyExcelFileName <> ""
Cells(myrow, 1) = MyExcelFileName
Cells(myrow, 1).Hyperlinks.Add Anchor:=Cells(myrow, 1), Address:=Cells(myrow, 1), TextToDisplay:=MyExcelFileName
MyExcelFileName = Dir()
myrow = myrow + 1
Loop
End Sub