in vb, you can use filesearch in excel up to 2003 vers, lookup that keyword
in help and i think one of the examples does it

in 2007 filesearch has been abandoned and you have to use dir, again the
examples in help contain an appropriate example, but with dir you have to
loop through each file using a counter x=x+1 so x ends up as the result

in both cases you can use wildcars too, so you could count the no of xls files

I have some code but not on me

somone else will no doubt beat me to it!

cheers

"Wanna Learn" wrote:

Hello

Is there a way to count how many files are there in a folder? thanks