Get the content of a sharepoint folder with Excel VBA

Question posted 2009 · +13 upvotes

Usually I use this piece of code to retrieve the content of a folder in VBA. But this doesn’t work in the case of a sharepoint. How can I do ?

Dim folder As folder
Dim f As File
Dim fs As New FileSystemObject

Set folder = fs.GetFolder("//sharepoint.address/path/to/folder")

For Each f In folder.Files
    'Do something
Next f

EDIT (after a good comment by shahkalpesh) :

I can access to the sharepoint if I enter the address in Windows Explorer. Access to the sharepoint needs an authentification, but it’s transparent, because it relies on the Windows login.