VBA: Open File as Not Read-Only

[hahdawg]

In VBA, I want to automatically answer "No" to an "Open as read-only" prompt that pops up whenever I open a workbook. Is there a way to do this?

I tried WorkBooks.Open FileName:="Book1", ReadOnly:=False, but that didn't work.

 

[Richard Schollar]

Hi Try:

WorkBooks.Open FileName:="C:\Book1.xls", IgnoreReadOnlyRecommended:=True

 

[hahdawg]

I've been looking for this for a long time. Thanks!

 

[fulhuaa]

thanks