Opening a workbook, maintaining "read-only" prompt

[Zenkai]

I am opening a workbook using

workbooks.open("book.xls")

If it is already open, excel is opening it as read only. I would like for it to instead display the dialog box wherein the user can choose whether to open the book "read only" or "notify" or "cancel." How can that work?

-Nick

 

[ETID]

Looking at the quick info in the vba editor, I see that notify is a value to decalare...but I dont know the syntax or the value that propts the user...try something like

Workbooks.Open ("path\workbook_name.xls"), , , , , , , , , , notify:=1

or maybe even notify:=0 or -1 ?

 

[Zenkai]

None of the workbooks.open declarations will work here. Notify will send the workbook into the notification queue if indeed it is read-only, but will not bring up the dialog box, as I wanted.