Zip Files (Class Module)

Access class module, although should work in Excel with minor modification, that automates zipping files, with parameters for the following:


  • Output Name
  • Output Path
  • File Names (paths as single file, semicolon-delimited string, or a single dimension array)


  • Create Method
  • Add Method (accepts full path of single item)

Right-click to Save Target As: ZipCollection.cls

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License