Hi Tim,
Thanks for your reply.
Is it possible to password protect a zip file using VB code?
Why do we handle various type of other documents in VBA? Do you know how to
password protect a PDF file?
Regards
On Sat, Jul 20, 2013 at 11:34 AM, Tim Lewis <tlewis@innovativecg.com> wrote:
> **
>
>
> There are a couple of options that I can think. Someone else may think of
> something else.
>
> Since the file types vary, one option is to zip them with the default
> Windows zip program.
>
> My favorite option would be to extract the information from the file, put
> it into a Word document or spreadsheet if it is data that is better suited
> that way. Then password protect and send the document or spreadsheet. The
> would require more work, because there would be different subroutines based
> on the type of document.
>
> Tim
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
> Behalf Of Saurabh Kushwaha
> Sent: Friday, July 19, 2013 12:58 PM
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] Password protecting a file (PDF, CSV, etc)
>
>
> Hi Guys,
>
> I have a problem.
>
> I have around 10-12 files at some location in my PC of various format(xlsx,
> csv, pdf, etc). I have to write a VBA code which makes all the file
> password protected and mails it to a group of people.
>
> Mailing the file is not an issue. Making xlsx file password protected is
> not an issue. How to make a file of different format (pdf, csv, etc)
> password protected using VBA code?
>
> Please help.
>
> Regards
> --
> Saurabh Kushwaha
> Corporate & Investment Banking, Barclays, Mumbai, India
> Class of 2011, NSIT, Delhi University, New Delhi, India
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
--
Saurabh Kushwaha
Corporate & Investment Banking, Barclays, Mumbai, India
Class of 2011, NSIT, Delhi University, New Delhi, India
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar