I need a master list from an excel folder, how to do it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have an excel folder with over 200 files in it. i would like to have a
master list of all the files but cant figure out how to extract a list. any
sugestions?


thanks
 
i have an excel folder with over 200 files in it. i would like to have a
master list of all the files but cant figure out how to extract a list. any
sugestions?


thanks
Click to expand...

Are you doing this in Microsoft Access (the subject of this newsgroup)
or in Excel? If the latter, I'd suggest reposting in an Excel
newsgroup.

In either case, open the VBA editor (Macro Editor in Excel) and look
for help on the Dir function.

John W. Vinson[MVP]
 
1. Create a blank text file in the same folder as the Excel files.
2. Rename is to "CreateList.bat"
3. Open it in notepad and enter this:

@echo off
dir -d /b *.xls > MyFileList.txt
pause

4. Save the file.
5. Run the file and it will create a text file called "MyFileList.txt" that
contains a list of only the Excel file. It will not list other files or any
folder names. There is intensionally no "path" given so it will do this
from whatever folder it is run from, so it needs to run from the folder the
excel files are in. It will overwrite the file with new data everytime it
is run.
 
Back
Top