Hi,
I need to get filename of all *.xls files in specific directory and put it
on the active worksheet.
I don't know where to start .
Plese help.
Thanks in advance,

Marijan

Hi
have a look at
http://tinyurl.com/yvvvm

-----Original Message-----
Hi,
I need to get filename of all *.xls files in specific
directory and put it
on the active worksheet.
I don't know where to start .
Plese help.
Thanks in advance,

Marijan


.

thanks

Sub ListFiles()
Dim I As Integer
Cells.Delete
With Application.FileSearch
.LookIn = CurDir
.Filename = "*.xls"
If .Execute 0 Then
For I = 1 To .FoundFiles.Count
Cells(I, 1) = .FoundFiles(I)
Next I
Else
MsgBox "There were no files found."
End If
End With
Range("a1").Select
End Sub

Peter

marijan glavac wrote in message
...
Hi,
I need to get filename of all *.xls files in specific directory and put it
on the active worksheet.
I don't know where to start .
Plese help.
Thanks in advance,

Marijan