| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Encrypt 2007 xlsx file using VBA
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Encrypt 2007 xlsx file using VBA
The third argument of the workbook SaveAs method is Password, so you can use
that to encrypt workbooks. See help for SaveAs. -- Jim "WhytheQ" wrote in message ... | 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Encrypt 2007 xlsx file using VBA
Thanks Jim. Jason. On 8 Sep, 12:17, "Jim Rech" wrote: The third argument of the workbook SaveAs method is Password, so you can use that to encrypt workbooks. *See help for SaveAs. -- Jim"WhytheQ" wrote in message ... | 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
| can't open .xlsx file in excel 2007 | Excel Discussion (Misc queries) | |||
| Can't open .xlsx file in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Slow Startup from an existing XLS or XLSX file | Excel Discussion (Misc queries) | |||
| Can not open .xlsx file in Office 2007 Beta 2 | Excel Discussion (Misc queries) | |||
Linear Mode
