Creating an Excel list of Excel Files

**kasimagj** · 07-02-2008, 11:57 AM

I have a folder filled with many different excel files.

Is it possible to create a list, in excel, that populates all of the file names from a folder?

**Macdave_19** · 07-02-2008, 11:59 AM

This code will go into a set folder and extract all the .xls filenames

just attach it to a button

Please Login or Register  to view this content.

**kasimagj** · 07-02-2008, 12:19 PM

I get a compile error with 'Sub Filename()' what do I need to fix?

**ravishankar** · 07-02-2008, 12:27 PM

Hi
Replace filepath from D:\my documents\ to your folder path and runt the macro

Please Login or Register  to view this content.

ravi

**kasimagj** · 07-02-2008, 12:39 PM

for some reason it doesn't seem to work. When I run it, it moves down one row with blanks. I realized that they aren't .xls, they're .txt. So i changed the .xls -> .txt.

Why doesn't this still work?

**modytrane** · 01-13-2009, 01:58 PM

Code provided by Macdave works fine.
Look at the attached example.
Enter your path name in K1 [e.g. C:\Sales\Reports] and file type in K3 [e.g. .Doc].
And click the button.
List appears in column A.
modytrane