Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Create a password protected Zip file


Hi Experts,

Kindly help me.

I have a query and despiratly need your help.I want to creat a zip file with password protection.please suggest me.

Explaination to the requirement:

There are 4 files in a folder,I want to convert that folder to password protected zip file and then attach the file in the mail, using VBA(Macro).

PLEASE help me.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Create a password protected Zip file

hrdk mstry expressed precisely :
Hi Experts,

Kindly help me.

I have a query and despiratly need your help.I want to creat a zip file with
password protection.please suggest me.

Explaination to the requirement:

There are 4 files in a folder,I want to convert that folder to password
protected zip file and then attach the file in the mail, using VBA(Macro).

PLEASE help me.


Have you tried the options in the SaveAs dialog? This may require a zip
utility such as WinZip or the like.

I use my own file explorer which has a SaveAs option on the right-click
menu. It works nicely with files but I've never tried it with a zip
archive. I'll test this out and report back...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XLS password protected file JacquesT Excel Discussion (Misc queries) 5 December 25th 08 02:02 PM
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. Daniel Excel Worksheet Functions 0 June 23rd 05 11:56 PM
bypass password when update linking of password protected file Yan Excel Discussion (Misc queries) 1 February 7th 05 11:29 PM
PASSWORD PROTECTED FILE Tom Ogilvy Excel Programming 2 September 10th 03 01:08 PM
Save protected file into unprotected file without password Paul Excel Programming 3 August 2nd 03 05:17 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"