Zip multiple Sub-folders or filesD:- in a particular folder & files

  • Hi Friends,
    I'm new to this forum. I'm facing a peculiar problem. Every month we have a salary files which we need to send it to region for updation. There are around 165-170 salary files which are kept in 100 different sub-folders & sometimes if the file count is less then folders are not created, directly files are saved in the "MainFolder" (pls refer the example below).


    For example:
    D:\Zip\Mainfolder\Folder1
    D:\Zip\Mainfolder\Folder2
    D:\Zip\Mainfolder\Folder3
    D:\Zip\Mainfolder\Folder4
    D:\Zip\Mainfolder\salaryfile1.xls
    D:\Zip\Mainfolder\salaryfile2.xls


    1st four are folders which needs to be zipped & last 2 are excel files which needs to be zipped.
    Is there anyway by which, whatever data is stored in folder "D:\Zip\Mainfolder\" be it a sub folder or file it should get zipped.
    Kindly help.


    Regards,
    Benhe