VBA open password protected file in read only mode

[megtoma]

Hi,

Does anyone know how to alter the below code to open it in read only mode?

Workbooks.Open Filename:="\\xxx\jjj\ (file://\\xxx\jjj\Exits\High)\Phase3 WP1.xls", Password:="zombie"

Many thanks in advance,

[mancubus]

hi.

add:
, ReadOnly:=True

[megtoma]

thank you . my query is solved
:biggrin:

[mancubus]

you are welcome.
thanks for the feedback and marking the thread as solved.