OPen excel workbook...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
Sub ReadOnly()
Workbooks.Open Filename:="E:\EXCEL\MySpreadSheet.xls", ReadOnly:=True
End Sub
 
That's the same thing I had before only you aren't catching the Workbook
object that is returned from the Open command.
 
Back
Top