Article: Count Files (with a specific extension or not) in a Folder

[Ken Puls]

You can view the page at http://www.excelguru.ca/forums/conte...t)-in-a-Folder

[Lavalamp]

I've been using this on my PC with no problems, I've now got a Mac and I can't seem to make it work on here. Any tips?

[LQuintero]

Hi Ken. Very good code.

It seems all the charm is in there:


Set objFso = CreateObject("Scripting.FileSystemObject") Set objFiles = objFso.GetFolder(strDirectory).Files

In my case I need not only to count files but also to process each individual file after getting that number of files. Using a For Next loop. How can I index each file to do that? is there any other attribute to use?

Thanks.