i want to make file name list in excel (by using batch file) from one Folder can u pl

[shibinpanayi]

i want to make file name list in excel (by using batch file) from one Folder
can u please help me?

 

[strollin]

You could run a batch file like this:

@echo off
dir /A-D-H > file_list.csv

which will create a list of files from the current folder and put it into a file called file_list.csv which is a filetype that excel can open. The info in the spreadsheet will probably need lots of cleanup to get it into a useable format.

Here's a more complete batch file. You'll need to edit the path to Excel on your system.

@echo off
REM Check to see if user entered a folder, otherwise use current folder
if %1.==. goto curr_dir
dir %1 /A-D-H > file_list.csv
goto _excl
:curr_dir
dir /A-D-H > file_list.csv
:_excl
REM Invoke excel
"C:\Program Files\Microsoft Office"\OFFICE11\excel.exe file_list.csv