title: Open + Edit Excel file from Sharepoint
body: <p>I am trying to open an excel file from a sharepoint library bearing the same name via VBA. Here are variables</p>
  
  <p>Define Variables:</p>
  
  <pre><code>Private Master_File As String
  Private Master_FileLocation As String
  Private Master_Open As Workbook
  </code></pre>
  
  <p>Assign_Variables:</p>
  
  <pre><code>Master_File = "Master Data.xlsx"
  Master_FileLocation = "http://sharepoint/page"
  
  
  Sub Open_Master()
  
      Application.ScreenUpdating = False
      Application.AskToUpdateLinks = False
      Application.DisplayAlerts = False
  
      On Error Resume Next
      Set Master_Open = Workbooks.Open(Master_File)
  
      If Master_Open Is Nothing Then
  
           Workbooks.Open FileName:=Master_FileLocation &amp; "/" &amp; Master_File, ReadOnly:=False
  
      End If
  
    End Sub
  </code></pre>
  
  <p>The code runs with no errors yet no excel file is opened. When I click on the file and copy the "shortcut" directly from my internet explorer browser, this is what appears:</p>
  
  <pre><code>   http://sharepoint/org/%20Master%20Data/%20Master%20Data.xlsx
  </code></pre>
  
  <p>When I copy this path and paste it into a folder search bar I am able to open the folder. Therefore, I know the file + folder exists. I also understand some functions such as ChDir and GetOpenFileName don't work with HTTP. That said, my function is pretty simple and doesn't require those functions. Any help would be appreciated.</p>