ReadOnly = NO

[dspilberg]

I have a macro that opens another file sent by someone I dont know. When the
macro opens that file there is a msgbox pop up telling me that the readonly
mode is recommended unless I need to change something.
I want to say NO to the Msgbox automatically, which means that I need to
make changes in that file and not open it in the readonly mode.

Do you have any suggestion?

Thanks.

Daniel (Brazil)

 

[Tom Ogilvy]

Use the IngoreReadOnlyRecommend argument to the workbooks.Open method:

IgnoreReadOnlyRecommended Optional Variant. True to have Microsoft Excel
not display the read-only recommended message (if the workbook was saved with
the Read-Only Recommended option).

workbooks.open "Mybook.xls", IgnoreReadOnlyRecommended:=True

 

[dspilberg]

It's working perfectly!!!!
Thanks a lot Tom, I've been reading from other people's questions and saw
you did answer many of them. It's great to have people like you to share
their knowledge!