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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
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