Excel VBA macro to encrypt a Workbook or Spreadsheet

[wifigoo]

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.

 

[Ron de Bruin]

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

 

[wifigoo]

Thanks Ron.

Actually, encrypt, compress (zip) and email is exactly what I am looking
for. If I am not mistaken your examples do not encrypt the ActiveWorkbook and
the mailing functionality is limited to Outllook. Unfortunately, I cannot
tell in advance which email client will be used. Therefore, I would like the
VBA macro to use the default email client. It would be disappointing if
Microsoft was only interested in supporting 100% Microsoft solutions. I find
it hard to believe that they haven't thought that users could be using other
email clients than Outlook.

Thanks for the link, nevertheless.

 

[Ron de Bruin]

Hi

encrypt

No you need a third party program

the mailing functionality is limited to Outllook

No good way for all mail programs

You can try CDO if you are the one that install your program on every machine
http://www.rondebruin.nl/cdo.htm