Thread
:
Open Excel from MS Access and Password Protect Workbook
View Single Post
09-21-2017, 02:32 AM
Debaser
Windows 7 64bit
Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
You should be using your wkbook variable and not ActiveWorkbook, and you should specify the file format as well:
Code:
wkbook.SaveAs FileName:=fileToSaveAs, FileFormat:=56, Password:="ANTHEM" wkbook.Close
Debaser
View Public Profile
Find all posts by Debaser