VBA Look Through Folder and Open Files Not Listed in Master File

So I have a master document and several hundred files with different date suffixes in the same folder. On the master document I want to list the date code and some various information in the file itself. The folder will be updated regularly so I want to be able to run the report periodically and add any new dates to the list.

So how do I do the following:

1. Search each file name in a folder
2. If the file is on my list, skip it. Else open the file.
3. Preform a function to the open file.
4. Close the file and proceed to continue checking the folder.

I cobbled together the below from various sources but it seems to have the problem of opening every file after a new file is found (eg if I have 100 files in the folder and only 97 is new, it will open file 97 to 100).

Please Login or Register  to view this content.