Will other users of this spreadsheet require the winzip
commandline program to be installed? If that is the case
this is not an appropriate solution for me. If so, is
there anything else that can be done?

-----Original Message-----
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

.