I want an excel file which should contain the list of file NAMES of one perticular folder in hard-disck. How do I get this?

for ex. C:\ANISH folder contains three file for exp. 1)anish.xls 2) neha.xls and 3) bhavin.zip

now i want the xls file which shold contain only this three file NAME not anything else other than this.

File should contain only

anish.xls
neha.xls
bhavin.zip

not even date, time or file size.


Please help me urgently. Send mail to me on [emailprotected]
http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm#kbhowtoGo to your DOS command prompt, Goto the directory that you want to list (use the CD command) and then type the following command after the > prompt....dir /b/o:e>OUTPUT.xls This will CREATE an excel file called OUTPUT and list the contents of the directory Name and Extension only and in extension order. *Note that you do NOT have to create the Excel file first, the command will do it for you and place it in the directory that is in the path of the command.
Good Luck
how do i get filecount and date each day that batch file is run and send to excel sheet


Every day keep appending the excel sheet with new row

date number of file
1/10/2004 200
1/11/2004 201
1/12/2004 200

.................. and so on