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).
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.