Encrypt 2007 xlsx file using VBA

  • Thread starter Thread starter WhytheQ
  • Start date Start date
W

WhytheQ

Is it possible to Encrypt an xlsx file using VBA?
(I'm creating 50 or 60 files on the fly and attaching them to emails -
manually adding passwords will be painful!)

Any help much appreciated.
Jason.
 
The third argument of the workbook SaveAs method is Password, so you can use
that to encrypt workbooks. See help for SaveAs.

--
Jim
| Is it possible to Encrypt an xlsx file using VBA?
| (I'm creating 50 or 60 files on the fly and attaching them to emails -
| manually adding passwords will be painful!)
|
| Any help much appreciated.
| Jason.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newline character in XML cell reference when creating xlsx from XMLzipped files 1
Possible error in VBA Workbooks.Open method for xlsx file 0
Excel 2003 save as .XLSX 10
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Converting xlsx to xl 4
Can't Edit my Excel Comments 10
Open an Excel file located in a web page - How to open it 0
Load a CSV into an empty, formatted XLS? 15

Back
Top