Following are the steps to import list of file names from a folder in to an Excel sheet.
1) Select a folder in which the files to be imported are saved. In this case, I've selected AV files folder on my desktop with 4 files in it.
2) Now, hold the Shift key on keyboard and right click on the folder and then select "Open command window here" from the context menu as shown in the picture above.
3) Now the command window pops up with the present directory. Type "dir / b>filenames.xls" in the command prompt and hit Enter.
4) The new Excel workbook "filenames.xls" has been created in AV files folder with the list of file names in it as shown in the picture above.
1) Select a folder in which the files to be imported are saved. In this case, I've selected AV files folder on my desktop with 4 files in it.
2) Now, hold the Shift key on keyboard and right click on the folder and then select "Open command window here" from the context menu as shown in the picture above.
3) Now the command window pops up with the present directory. Type "dir / b>filenames.xls" in the command prompt and hit Enter.
4) The new Excel workbook "filenames.xls" has been created in AV files folder with the list of file names in it as shown in the picture above.
0 comments:
Post a Comment