ReadOnly = NO
 

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)

ReadOnly = NO
 

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

--
Regards,
Tom Ogilvy


"dspilberg" wrote:

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)

ReadOnly = NO
 

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!

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"dspilberg" wrote:

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)