Thread: how do i use vba to zip folders?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote