title: How to open an excel file from a Sharpoint
body: <p>I'm trying to open an excel file from a sharepoint site using VBA. I used the code from <a href="https://stackoverflow.com/questions/19505513/open-an-excel-file-from-sharepoint-site">this</a> page, but all it did was pull up my file explorer. I have also tried this code which I usually use for opening a closed workbook, not on a sharpoint.</p>
  
  <pre><code>dim wbk as workbook
  set wbk = Workbooks.Open("Filepath")
  </code></pre>
  
  <p>Using this method returns an error telling me my file path is bad or non-existent, which my file path is correct. Any help would be appreciated. Thanks!</p>