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...

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


" wrote:

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...

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

"Mike Q." wrote:

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


" wrote:

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...