Hi there,
I have found following code trough which I can download the file from sharepoint
but I want to check if the file exists on sharepoint (Dont want to download all the files from sharepoint since I am dealing with 80,000 files)
Any thought
Thanks
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
Sub DownloadFileFromWeb()
Dim i As Integer
Const strUrl As String = "https://dspace.de.intranet.db.com/site0194/Final Data Repository/Lehman Brothers/Commodities/Close-out Documentation/Lehman Final Analysis - US Power.xlsx"
Dim strSavePath As String
Dim returnValue As Long
strSavePath = "c:\Documents and Settings\khamyog\Desktop\Lehman Final Analysis - US Power.xlsx"
returnValue = URLDownloadToFile(0, strUrl, strSavePath, 0, 0)
'MsgBox returnValue
End Sub