View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hzgt9b@nopost.com is offline
external usenet poster
 
Posts: 15
Default OPen excel workbook...

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