A A.Almeida [MVP] Feb 24, 2006 #2 Hi David The cheap easy way, if you have Excel 1 - On a command prompt use the command: dir > "filename".txt (eg: dir > SDlist.txt) 2 - Open the file in Excel, choose Delimited - Space. The difficult way -Use some code http://www.freevbcode.com/ShowCode.asp?ID=1487 http://www.exceltip.com/st/List_fil...Runtime_using_VBA_in_Microsoft_Excel/446.html The expensive way There is some software available just for this, search google for "list folders"
Hi David The cheap easy way, if you have Excel 1 - On a command prompt use the command: dir > "filename".txt (eg: dir > SDlist.txt) 2 - Open the file in Excel, choose Delimited - Space. The difficult way -Use some code http://www.freevbcode.com/ShowCode.asp?ID=1487 http://www.exceltip.com/st/List_fil...Runtime_using_VBA_in_Microsoft_Excel/446.html The expensive way There is some software available just for this, search google for "list folders"
