Friday, April 17, 2009

How to export file and folder names to Excel

Assuming you wanted to output all the files in C:\Test to Excel, you would select Start-Run, enter cmd and press enter. In the command prompt window, type:
dir C:\Test /b > c:\files.csv
then just open the c:\files.csv file in Excel.
You can also do this from Excel with a macro if you prefer.

No comments:

Post a Comment