源碼如下:
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 "沒(méi)有該文件系統(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è)操作過(guò)程用時(shí):"&CStr(t2-t1)&" 秒"End function之前武林網(wǎng)小編更新過(guò)類似的文章,大家可以參考一下
新聞熱點(diǎn)
疑難解答
圖片精選