Open workbook if not readonly. If readonly try again.

I am at a lost on how to acomplish a simple task.

I want to be able to open a workbook using a VB macro but if it is read-only (in use by someone else), I want the script to keep trying until I am able to open the workbook with write access. Any help would be appreciated.


Thanks,

Met

Is this what you are looking for?

Please Login or Register  to view this content.

Martinez:

Thanks for the quick response. Unfortunately, when I run the script listed above, the workbook is opened regardless of the the files status. I should clarify, the file is located on a local network and I need to be able to modify and save the file hence the reason that I need it to be writable.

Thanks,
Met

Great! Sorry my code wasn't working for you, but I know having a baseline always helps me.

Best,
Martinez