VBA to open multiple files with different, unknown file names

Originally Posted by jreed52

Hello-
I'm trying to build a macro to open multiple files at one time that will always be saved in a consistent drive. The problem is that sometimes there will only be one file for a month (ie only at month-end) and other times, there may also be additional files for different dates throughout the month. I wont know ahead of time how many files there will be, but they will always be saved in the same file name type that is "FILE DESCRIPTION MM-DD-YYYY". How can I build a loop that looks for a file on each possible day but doesn't error out if the file doesn't exist? Thanks!

Will there be files form other months in the same folder?
If yes, do you want to include or exclude those files?
If exclude, what month do you want?

This example will open all FILE DESCRIPTION files (regardless of date) in a folder.

Please Login or Register  to view this content.