Hello

I wrote a macro that checks the work progress of people in my team (there are Preparer, Reviewer 1 and Reviewer 2). The work of each person is finalized once they sign off a checklist (CL) in PDF.

I am using File = VBA.FileSystem.Dir in my code to check for the existence of PDF CL file in a folder, based on file name (Reviewer 1 and 2 have to add additional letters to file name, so file is recognized as completed by them).

My question is: is there a way to avoid changing file name, and the code will somehow automatically recognize who completed the file (let's say by time stamp) ?

Thank you for any suggestions.

Greg