Zipping of files - Help required

  • Hello,
    Please help me on the below zipping requirement. I have searched the web but am not able to get anything which can fulfill the below criterias. I am in urgent need of this code.


    1. The VBA code should go through all the folders and sub-folders and check each and every file in those folders and sub-folders.
    2. After checking the files, the VBA code should zip all the files which have not been accessed for more than 3 months. The accessed period should be something which I can change at a later stage. i.e - if I need to change it from 3 months to 1 month or 6 months.
    3. After zipping the files, the VBA should delete the original files and save only the zipped file.
    4. The zipped file should be saved in the same place where the original file was saved.