Monday, December 20, 2010

Zip Multiple files via Excel VBA

Using this template zip the multiple files with their folder name in one path.
Ex, 
Assuming this path......  C:\Program Files\
In this folder it contain many folders.
Get directory list of folder names and give this list to this template under the name "FolderList:"
In "Your Path:" put the path above mentioned, (i.e., where the folders and files are located) and click the "GetZipfiles" button.


**Before using this template you must save as this file with the name "ConvertToZip.xls"


Click here to download ConvertToZip.xlt

No comments:

Post a Comment