Below are my requirements for zipping.
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.