See
http://www.rondebruin.nl/windowsxpzip.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"wifigoo" wrote in message ...
Hello,

I've created a button in a spreadsheet that, when clicked, will encrypt and
compress a Workbook using IZArc's command line tool. Unfortunately, this
requires downloading and installing IZArc software. I would rather use an
Excel built-in function that would encrypt and compress a
Workbook/Spreadsheet thereby avoiding having to download and install IZArc.

Has anyone tried this? Or does anyone know where I may find information to
help me create such a Excel VBA macro?

Many thanks for your help.
Kindest regards,
Olivier.