| I developed a VBA function called =countfiles() which would take a file directory name as input and return the number of files in the directory. I could pass a filter to show only files that had a string in it.
This was useful when receiving files I could verify whether I had all the files I need before starting processing. |