Folder Inventory & Count for like named files

[sdnicsm]

I have a folder( "c:\pictures") with 5000+ files in it ending with the ".jpg" ext.

The files are started with a 6 number identifier followed by "-" & the number of the sequence of the files & then the ext.

ie:
123456-1.jpg
123456-2.jpg
112233-1.jpg
112233-2.jpg
112233-3.jpg

How can I inventory and count the files and list only first identifying numbers"123456" & number of like files count

ie:
123456 2 files
112233 3 files

VR

SDNICSM

[theDude]

This should work for you; the macro will write the inventory results to the active worksheet in Excel:

Please Login or Register  to view this content.

Hope this helps,
theDude