title: vba Excel - How to Check if a SharePoint Website File is Open
body: <p>I've searched the internet for the answer to this and keep running into issues getting it to work. </p>
  
  <p>I need to check if a file at the below location is open/locked, and then have the code wait 15 seconds and then try again. Right now if someone else has the file open a dialog box opens asking if I want to open read only, which I don't want. I tried using Application.DisplayAlerts = False to get the message not to appear but that didn't seem to work. So I have two main issues:</p>
  
  <ol>
  <li>Checking if the file is open and waiting to try again. </li>
  <li>Stop the dialog box from opening asking to open as read only. </li>
  </ol>
  
  <p>Workbooks.Open filename:= _
                   "<a href="https://somecorporatewebsite/sites/TNKYWest/Engr/ASE%20Updates/Shared%20Documents/ASENW" rel="nofollow">https://somecorporatewebsite/sites/TNKYWest/Engr/ASE%20Updates/Shared%20Documents/ASENW</a> Updater.xlsx"</p>