OPen excel workbook...

[Guest]

I want to open an excel workbook as read-only and suppress any and all
user-prompt messages - How can I do this?

Here's what I have tried:
Set xlReportWkbk = Workbooks.Open(strPath & strReportWkbk, , xlReadOnly, , ,
, True, , , False, False)

But I still get prompted is the targeted workbook is already open...

 

[Guest]

Sub ReadOnly()
Workbooks.Open Filename:="E:\EXCEL\MySpreadSheet.xls", ReadOnly:=True
End Sub

 

[Guest]

That's the same thing I had before only you aren't catching the Workbook
object that is returned from the Open command.