Auto-answer Read-Only to Password Dialog pop-up during macro

[Asher]

One of my macro's opens a number of files while it runs. One of these files is Password protected on open. How do I write in my code to click the Read-Only button so it stops interrupting the Macro?

I have attached a pic of the Dialog Box.

pwordDialogDuringEVMacro.JPG

[rory]

Have you tried specifying the ReadOnly:=True argument when opening the file?

[Asher]

Thanks Rory! That works!