LIsting Files in Excel

S

Sudhir Amin

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.
 
B

Bob I

from the command prompt in the folder in question do a

DIR *.XLS > filelist.txt

Then Import the text file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Renaming a worksheet in excel 3
How do i collate data from different sheets in one sheet? 8
Best solution for removing duplicate content with conditions? 2
Extract the Sheet Name 3
Excel Jululian 1
Summary from multiple sheets 1
Text data -- linking Excel sheets 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Top