Counting Files In A Folder (1 Viewer)

[Oakleaf]

I used to count files in a folder and get their sizes by using "Scripting.FileSystemObject", how do I do this in office 2010?

 

[khodr]

Hi OakLeaf,
refer to this link I hope it helps you.
http://www.devhut.net/2012/07/06/vba-count-files-in-folderdirectory/

 

[Oakleaf]

Many thanks khodr.

The way you indicated was roughly the the method I was using. I have looked at this several time over Christmas and the New Year and still I have no idea why it stopped working.

In the end I scrapped the routine and started again. It now works O.K.

As an old school friend of mine used to say " Oh the perversity of Inanimate objects!"