Thread: Zip Files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Zip Files

Is there a way to create zip files using code in excel?
Something that could browse files, select some and zip
them up.


You need the WINZIP command line utility for that. Search the WINZIP
site www.winzip.com for it and install it. Then you can use SHELL to
start the utility after constructing the proper commandline for it as a
string.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com