Re: Link/Import SharePoint Excel File
this is a few years old but I know it worked for me at work. this will download a file from sharepoint. you will need the full path of the file you want to download
Private Declare Function URLDownloadToFile Lib "urlmon" Alias _
"URLDownloadToFileA" ( _
ByVal pCaller As Long, ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long
Dim i As Integer
Const strUrl As String = "url and file name with extension of file you want to down load"
Dim strSavePath As String
Dim returnValue As Long
strSavePath = "path and file name with extension of where you want to save the file"
returnValue = URLDownloadToFile(0, strUrl, strSavePath, 0, 0)