Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)
Hi all
I upload a new page today with code to create Zip files with the free Zip program 7-zip.
This program is also very useful if you want to open Office 2007 files as a archive
without changing the extension to .zip so you can see/edit the files in the archive.
Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)
http://www.rondebruin.nl/7zipwithexcel.htm
I will add a Unzip page to my site for 7-zip it next week
For examples for WinZip or the default Windows Zip program see the Zip (compress) section here
http://www.rondebruin.nl/tips.htm
Have fun and let me know if you have suggestions or find a bug
Ron,
7zip is great. I started using it when Windows default zip wouldn’t handle different types of encryption and I find it much better than anything else. Winzip is dead to me.
Agree with comments about 7-zip. I`ve used WinZip with the optional extra install for command-line access, our standard at work is ZipCentral which is o.k. but has no command-line interface and isn`t being developed any further. Read about 7-zip in a magazine and haven`t looked back. Some of the options vary depending on whether you`re creating a .zip or the native 7-zip archive format so there`s some trial and error needed.
Hi
Good to read that I ma not the only one that like the program
FYI
I add the page with a few basic unzip examples
Link is on the Zip page
Have fun