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.


Yes they do.

Search google for VB compression routines is all you can do then.

Regards,

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