excel vba - Reading all folders in VBA -
i put following code in excel. script found on net.. sub testlistfolders() application.screenupdating = false workbooks.add ' create new workbook folder list ' add headers range("a1") .formula = "folder contents:" .font.bold = true .font.size = 12 end range("a3").formula = "folder path:" range("b3").formula = "folder name:" range("c3").formula = "size:" range("d3").formula = "subfolders:" range("e3").formula = "files:" range("f3").formula = "short name:" range("g3").formula = "short path:" range("a3:g3").font.bold = true listfolders "c:\foldername\", true application.screenupdating = true end sub sub listfolders(sourcefoldername st