Microsoft Office Forums - View Single Post - Open Excel from MS Access and Password Protect Workbook

Thread: Open Excel from MS Access and Password Protect Workbook

View Single Post

Old

08-20-2017, 05:27 PM

charlesdh

charlesdh is offline

charlesdh uses Windows 7 32bit

Windows 7 32bit charlesdh uses Office 2010 32bit

charlesdh uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

charlesdh is on a distinguished road

Default

Hi,

A bit of code you may try. Not tested.

Code:

With ActiveWorkbook
.SaveAs FileFormat:=xlNormal, Password:="YourPassword", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
.Close
End With

Reply With Quote