Introduction:
This macro can be used to count how many files exist in a folder and, if passed the file extension, can also be used to count only files of a specific type. (For example "xls" files.) I've actually published two articles along this vein at
VBA Expresss, but this one uses the File System Object (some know it as the File Scripting Object, or just FSO,) to do it. The biggest reason for the re-write is that I needed to use this in an Excel 2007 instance, which does not support the FileSearch method.
If you are looking for a version to count the files in a folder AND subfolders, then
look here.
...
Knowledge Base Articles By Category
Recent Forum Posts
Distinct Group by Index
Hi there, and welcome to the forum.
The steps to do this are:
- Select the Account column of your data -> Transform -> Group
... Ken Puls Today, 06:12 PM