Looping thru files in folder

You should take a look at the dir() function in VBA, Its likely the simplest way to loop files in a folder. It can be done recursively as well. Otherwise using a file system object (fso) to loop the files in a folder or sub folder.

This should get you started.

Please Login or Register  to view this content.

Alternative to VB Script using VBA
If the workbook hosting the code is in the same folder the code below would open each file for potential action. If the host workbook is not in the same folder, you would need to substitute the actual path for 'ThisWorkbook.Path' as a string, eg. "C:\User\Document\xl"

Please Login or Register  to view this content.

This is very generic, but you can add code to spice it up if needed.

Originally Posted by rpinxt

Be aware the files are not named in such a way that I can control the sequence.

You've got some pretty good answers here so I won't muddy the waters there. I will add, however, that you can't control the sequence anyway. The order in which files are in a Windows directory are undefined. If you loop through all the files you may detect a pattern but Windows does not guarantee for any given path that you can predict what the sequence will be.

Originally Posted by 6StringJazzer

You've got some pretty good answers here so I won't muddy the waters there. I will add, however, that you can't control the sequence anyway. The order in which files are in a Windows directory are undefined. If you loop through all the files you may detect a pattern but Windows does not guarantee for any given path that you can predict what the sequence will be.

I believe the windows default is numeric-alphabetically sorted in the directory. The problem in most cases is the inconsistency of the user entries in formatting the names.

If you did need to open them in order, you would store the file names into an array, collection or dictionary. Sort the construct and then loop the construct to open the files. As mentioned naturally looping the files could give you an unexpected order of the files, which may be fine for most uses.

Glad to help. thanks for rep+.