Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List files in a directory to Excel? 1

Status
Not open for further replies.
Feb 1, 2005
144
US
Hi I was wondering if anyone knows of any programs or cmd prompt to list all the files in a directory into excel or txt file.

Thanks.
 
dir > file.txt

This will list everythijng in the current directory to a text file called file.txt

Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
 
Sorry, it got submitted early.

You can use any parameter that the command dir accepts to format trhe output of the file.

dir /AR >readonlyfiles.txt

This will list only the files with the Readonly attributes. into the file readonlyfiles.txt.

Hope this helps

Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top