Downlad Sharepoint Document Library's Specific View only using Excel VBA

[krishnaoptif]

Hi Experts,

I want to download SharePoint 2010 document library's specific view only using Excel VBA where I have few filtered metadata columns.

May you please help on this

 

[krishnaoptif]

Can someone help me on this please ?

 

[Tom_H]

I am affraid it is not possible. I might be possible if you open every file but my files are big and it will just take too much time to open every file.
I use the following code to list files in a SharePoint document library app. See below ..
It works very vell and it is fast but there is no way to get the metadata , I have one "Decided Yes/No"

Public Sub Get_all_files_in_folders(tbl As ListObject, ObjSubFolder As Object, myDir As String)
Dim r As Integer
Dim objFolder As Object
Dim objFile As Object

Dim objDSO As Object
    
    r = 1
    For Each objFile In ObjSubFolder.Files
        If Right(objFile.Name, 5) = ".xlsm" Then
            tbl.DataBodyRange.Cells(r, 2) = Left(objFile.Name, Len(objFile.Name) - 5)
            r = r + 1
        End If
    Next
End Sub