Function listFilesPath(filepath)
  t1=Timer()
  Debug.WriteLine "****現(xiàn)在開始執(zhí)行計(jì)數(shù)，用時(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)在完成計(jì)數(shù)，用時(shí)："+CStr(t2)
Debug.WriteLine "整個(gè)操作過程用時(shí):"&CStr(t2-t1)&" 秒"
End function