• Here's a quick example to count JPG files based on an example in VBA help for the "Files" property:

    The code actually throws up a message box that names all of the files as well as gives you the count of the jpg files. I modified it to suit your needs, but left some superfluous stuff like listing the files for illustration purposes.

    I hope this gets you started.

  • Hi Jim,

    Here is another example, using the DIR() function. There is also a function to import a specified file.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!