Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2008

Tip: Looking for answers? Try searching our database.

Excel VBA macro to encrypt a Workbook or Spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
wifigoo - 12 Apr 2008 10:51 GMT
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 - 12 Apr 2008 11:51 GMT
See
http://www.rondebruin.nl/windowsxpzip.htm

Signature

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

> Hello,
>
[quoted text clipped - 10 lines]
> Kindest regards,
> Olivier.
wifigoo - 12 Apr 2008 16:11 GMT
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.

> See
> http://www.rondebruin.nl/windowsxpzip.htm
[quoted text clipped - 13 lines]
> > Kindest regards,
> > Olivier.
Ron de Bruin - 12 Apr 2008 19:58 GMT
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

Signature

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

> Thanks Ron.
>
[quoted text clipped - 26 lines]
>> > Kindest regards,
>> > Olivier.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.