Open Excel from MS Access and Password Protect Workbook

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Open Excel from MS Access and Password Protect Workbook

09-21-2017, 02:32 AM

Debaser

Windows 7 64bit Open Excel from MS Access and Password Protect Workbook

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protect a workbook without using a password.	aussiemight	Excel	3	04-26-2017 07:32 PM
how to create a box in word document that takes a password to open an access field	kawtharz	Word VBA	2	08-13-2015 12:43 AM
Need to open an Excel WorkBook from Word VBA	Pierre-Hugues	Word VBA	4	10-07-2013 06:27 AM
Unable to open Excel 97-2003 workbook	J Partridge	Excel	1	11-07-2010 03:26 AM
password protect excel file?	Dawg751	Excel	2	01-28-2010 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 PM.