Function listFilesPath(filepath)
t1=Timer()
Debug.WriteLine "****現(xiàn)在開始執(zhí)行計數(shù),用時:"+CStr(t1)
Set fso=CreateObject("scripting.filesystemobject")
Set myfolder=fso.GetFolder(filepath)
If fso.FolderExists(filepath) then
Set subcol=myfolder.SubFolders
Set filescol=myfolder.Files
For Each file In filescol
Debug.WriteLine filepath+"\"+file.name
Next
If subcol.count>0 Then
For Each folder In subcol
'Debug.WriteLine filepath+"\"+folder.Name
listFilesPath(filepath+"\"+folder.Name)
next
End if
Else
Debug.WriteLine "沒有該文件系統(tǒng)"
End if
Set filescol=Nothing
Set subcol=nothing
Set fso=Nothing
t2=Timer()
Debug.WriteLine "****現(xiàn)在完成計數(shù),用時:"+CStr(t2)
Debug.WriteLine "整個操作過程用時:"CStr(t2-t1)" 秒"
End function