I have a file directory that gets new draft file every day. Each draft file is modified to a final version on the same day but it’s not saved as a different file name.
I have a for loop that checks the file directory & adds each file name to an array.
Ideally, i’d like a conditional statement that only picks up on the files that have been modified after 30 mins of the file initially being created & appends the final version of the data to a weekly overview excel.
Can this be done?