Zipping of files

  • Hello,
    Can you please help me with a VBA code to zip all files on a folder / sub folder which are not accessed for more than 3 months. I am not able to find an such VBA code.
    The sub folder / folder changes from person to person depending upon the access provided. It would be great if the Top folder can be mentioned and all the sub folders will be identified by the VBA code and then zip the files.
    After zipping the file, the code should delete the original file and only keep the zipped version.


    I am struggling on this for days. You guys are my last hope


    Regards
    Lloyd

  • Lloyd,
    I have removed your email from your post. Spammers lurk around forums looking for email addresses. If you really like getting spam, then you should continue to post your email address, otherwise I suggest you not post it publically.

  • Hello,


    Thank you very much for the quick revert. I do not have any code at the moment. I am not even good at coding.
    I wanted to know if such a code exists which I can utilize.

  • I am really sorry but I had checked the link provided and I was not able to find anything which I could use. Maybe I am not doing it right.
    My requirements is as below.


    VBA code to zip any type of files on a folder / sub folder which are not accessed for more than 3 months. The code should keep the zipped file and delete the original file.

  • Hello,


    Let me confirm to you ... Ron's proposed code is fully operational ... :smile:


    Regarding precisely your requirements ... in my opinion, you should consider posting in the HIRE section ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)