Copy only files if Date Modified is on or after Date and Time in specific cell

  • On Sheet1 of workbook containing the code:


    H2 has a path to source folder
    i2 has a path to destination folder
    H5 has a result of a =NOW() formula, pasted as Values (e.g. 5.13.19 9:27 - as in May 13th, 2019 and 27 minutes past 9 in the morning)


    Need code to look through files in H2 folder, and if Date Modified is on or after Date and Time in H5, then copy only those files to destination folder in i2


    *I'll probably need to use the Microsoft Scripting Runtime Library - In the VBA editor add a reference (Tools, Add Reference) and look for Microsoft Scripting Runtime Library and tick its box.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!