This was precisely what I needed (much better than what I
had come up with)...thanks a bunch.
-----Original Message-----
Ron,

Is there also a easy way to count only the Excel files
for
example

You'd have to loop through the Files collection and check
the
extension.

Dim FSO As Object
Dim F As Object
Dim N As Long
Set FSO = CreateObject("Scripting.FileSystemObject")
For Each F In FSO.GetFolder("H:\Temp").Files
If StrComp(Right$(F.Name, 4), ".xls") = 0 Then
N = N + 1
End If
Next F
Debug.Print N



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ron de Bruin" wrote in message
...
Hi Chip

Is there also a easy way to count only the Excel files
for
example
with your example.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chip Pearson" wrote in message
...
Try something like

Dim FSO As Object
Set FSO = CreateObject("Scripting.FileSystemObject")
Debug.Print FSO.GetFolder("C:\Temp").Files.Count


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hawki" wrote in
message
...
Is there an easy way to count files in a given
folder?
TIA...






.