I have a file that is marked as recommended read only. I would like to have
my macro open the file alter it and save it but I can't seem to automatically
get rid of the message box when I open the file that asks if you would like
it to be read only.
I have tried
workbooks.open(file,,false)
And I have tried
Application.DisplayAlerts = False
workbooks.open(file)
Application.DisplayAlerts = True
The first method did nothing and the second method opened it as a read only
file.
Any suggestions?
Jim Rech - 12 Sep 2007 21:40 GMT
Workbooks.Open Filename:="C:\book1.xls", IgnoreReadOnlyRecommended:=True

Signature
Jim
|I have a file that is marked as recommended read only. I would like to have
| my macro open the file alter it and save it but I can't seem to automatically
[quoted text clipped - 13 lines]
|
| Any suggestions?