List of files in a folder and sub folder

[krishhi]

Hi,

How to create list of files in a folder/sub folder. I just want the file names only. I don't need any file attributes.

I found a article in kb but it doesn't help me. I am using excel 2007.

Thanks in advance,

krrish

[Bob Phillips]

Explain in what way it doesn't help.

[krishhi]

Sorry xld,

I got the right link here:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1042

by the way can any one explain this steps.

If .SelectedItems.Count <> 0 Then 
            xDirect$ = .SelectedItems(1) & "\" 
            xFname$ = Dir(xDirect$, 7) 
            Do While xFname$ <> "" 
                ActiveCell.Offset(xRow) = xFname$ 
                xRow = xRow + 1 
                xFname$ = Dir

[Bob Phillips]

It takes the first of the folder names selected and loops through processing every file in that older.

[krishhi]

It takes the first of the folder names selected and loops through processing every file in that older.

hey sorry to bugging you,

Dir(xDirect$, 7)

In this code, what is mean by 7?