title: Access VBA - To get data from Excel file stored in Sharepoint
body: <p>I have the below code working for me provided the "Model_data.xlsm" file is stored in my hard drive. Is it possible if Access can get the data from "model_data.xlsm" stored in Sharepoint?</p>
  
  <pre><code>Private Sub Update_manu_data_Click()
  
  Dim strXls As String
  
   strXls = CurrentProject.Path &amp; Chr(92) &amp; "Model_data.xlsm"
   DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12,   "Manufacturing_data", _
   strXls, True, "Combined!"
  
  End Sub
  </code></pre>