How do I open workbook programmatically as read-only?

Question

This is how I can open an excel file in vbA:

Workbooks.Open(file-path)

is there a way to specify that it should be open as read-only? The files I am opening have a password on them, and I always get the dialog that it can only be open as read only.

score 42 · Accepted Answer · edited May 23 '17 at 10:34

42

Does this work?

Workbooks.Open Filename:=filepath, ReadOnly:=True

Or, as pointed out in a comment, to keep a reference to the opened workbook:

Dim book As Workbook
Set book = Workbooks.Open(Filename:=filepath, ReadOnly:=True)

edited May 23 '17 at 10:34

Community

1
1

answered Aug 02 '10 at 16:11

LittleBobbyTables - Au Revoir

32,008
25
109
114

1

It is helpful to know that you should encapsulate the arguments in a parenthesis if you intend on storing the opened workbook in a variable using 'Set'. – CAD.Dev Mar 28 '16 at 02:08

score 15 · Answer 2 · answered Aug 02 '10 at 16:11

15

Check out the language reference:

http://msdn.microsoft.com/en-us/library/aa195811(office.11).aspx

expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)

answered Aug 02 '10 at 16:11

buckbova

1,213
6
11

Better response as it also makes it clear that *password* can be used on open. – brettdj Apr 01 '15 at 00:20

How do I open workbook programmatically as read-only?

2 Answers2

Linked