ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do i use vba to zip folders? (https://www.excelbanter.com/excel-programming/364314-how-do-i-use-vba-zip-folders.html)

scouse1

how do i use vba to zip folders?
 
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

how do i use vba to zip folders?
 
Ron de Bruin shows a few ways:

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

scouse1 wrote:

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


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com