I have a project to open a few hundred workbooks, run a macro that makes
changes, and then save them. It is possible that a few of the workbooks may
be in use by a user. So the opening of the workbook will pop up a message
box asking if one wants to open read only. These I don't want to open, but
instead log them so I can go back later and process them. I don't want to
have someone monitor the running of the macro. I'd like the macro to be
able to determine if read only and to not open it. I would think there is a
command I could call prior to the open that returns the file's status.

Thanks, Don <www.donwiss.com (e-mail link at home page bottom).