| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding columns to an Excel matrix and listing them in the PT | Excel Worksheet Functions | |||
| Excel - convert row address listing to columnar database | Excel Discussion (Misc queries) | |||
| How to find duplicate data in two tables,then listing it?(Excel) | Excel Worksheet Functions | |||
| Periodically listing files in a folder | Excel Discussion (Misc queries) | |||
| Listing Order of Open Windows in Excel 2003 | Excel Discussion (Misc queries) | |||
![Sudhir Amin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
