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