ExcelBanter - LIsting Files in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - LIsting Files in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/173405-listing-files-excel.html)

Sudhir Amin[_2_]

LIsting Files in Excel

Could you please let me know how do i get the names of about 10-12 excel file
names, which i have in a folder, listed in one excel sheet.

I have about 45 excel sheets in a folder. I want to know if there is any way
i can get the names of these excel sheets listed in one common consolidated
excel sheet one after another.

Bob I

LIsting Files in Excel

from the command prompt in the folder in question do a

DIR *.XLS filelist.txt

Then Import the text file.

Sudhir Amin wrote:

Could you please let me know how do i get the names of about 10-12 excel file
names, which i have in a folder, listed in one excel sheet.

I have about 45 excel sheets in a folder. I want to know if there is any way
i can get the names of these excel sheets listed in one common consolidated
excel sheet one after another.

All times are GMT +1. The time now is 01:58 AM.