none
Macro to aert when copy duplicate zip files RRS feed

  • Question

  • Hello All,


    I need to copy and move only the most recent zip file saved in my Desktop.


    I have several zip files in a folder and I need an alert message "Duplicate file found" only when I copy a zip file which is created or modfied  more than "10 minutes" in my system. The reason being I don't want to upload the old or incorrect zip file which was created atleast 10 minutes before.


    Ofcourse, deleting or moving the old version could avoid this, however, checking for a macro if possible.


    Could anyone help me on this plz.
    Thursday, October 17, 2019 5:41 AM

All replies

  • Hello Ruskn,

    Thank you for the code, the code generates the details of the files resides under the folder, such as type, size & number of all other files resides inside the folder.

    However, I need the macro to give alert only when I do an action copying the zip file which is created more than "10 minutes" from the time I am copying it.  And no action requires when I copy the zip file which is created in a folder within "10 minutes" from the time I am copying it.

    Please let me know if any further assistance requires.


    Thursday, October 17, 2019 5:52 PM