how do i use vba to zip folders?

[Guest]

i have managed to create folders and move files into various folders using
vba, is it possible to use some vba code to zip the folders?

 

[Dave Peterson]

Ron de Bruin shows a few ways:

http://www.rondebruin.nl/tips.htm
Look for "Zip (compress) file or folder with VBA code"