The Good NewsI was looking for a way to compress (not ZIP as in 7zip or WinZIP) Excel files for emailing and archiving. After a an hour or so of reading posts where this question was asked often and never answered for VBA, and often answered for those who can reliably say their users will have WinZIP (a fine product in my book...this problem is not a slight to that team) available.
Google brought me to Ron de Bruin's site, specifically this link:
I was so excited I immediately posted "Haven't tested this yet. Will commence now! ...."
Twenty minutes later I started writing ...
The ReviewOK. I tested it. Here's what I found
- Works as advertised!
- Code is well structured and is well documented.
- There is only one black box, meaning code I do not yet understand but it works every time. This is an opportunity for me to learn from someone who did it right rather than my usual hack 'til it quits method.
- Any changes I need to make to fit my needs will be easy to make.
- My only "complaint" is such a small nit if Ron de Bruin were to see this "complaint" without me first saying it is tiny, minuscule, and barely worth a thought he might block me from his site, and maybe call Interpol to keep me out of Netherlands.
OKAY...now that I've wasted time and energy explaining how small it is, it using the word "zip". I prefer "compress" because
- "Compressed" is the word used by the people who developed the compressed folder structure.
- "ZIP" is something I think of when referring to the products like WinZIP, and PKZIP before that. Those are much richer products.
- "Zip" is also a new-to-me method of handling files where one can add the "zip" extension, insert a file within the ZIPped file thus modifying the XML (this is my understanding of what happens, then removing the "zip" extension to reveal a modified filed.
LAST NOTE ON HOW TINY THIS COMPLAINT IS: I believe all of the code Ron has provided was written before the zip/XML method became commercial.