Sub 遍历子文件()
Dim Filename As String, mypath As String, k As Integer
mypath = ThisWorkbook.Path & "\2011年报表\"
Range("A1:A10") = ""
Filename = Dir(mypath, vbDirectory)
Do
If Not Filename Like "*.*" Then
k = k + 1
Cells(k, 1) = Filename
End If
Filename = Dir
Loop Until Filename = ""
End Sub