title: Determine files of a specific type in a folder without using loop
body: <p>Is there any way to use the FileSystemObject in VBA to determine the number of files of a specific type, such as .PDF, in a folder without using a loop such as</p>
  
  <pre><code>For Each file In folder.Files
      'Check file type and count
  Next
  </code></pre>