Downloading the last modified file from a SharePoint folder

[Fantast]

Hi.

I have a https link to a SharePoint folder where some Excel files reside. I need to download the last modified file in that folder through VBA. The answers I have found by googling assume that I have a network path to the SharePoint folder (\\sites\...\documentsFolder\). However, I only have access to that folder through a https connection... Does anyone know a way to achieve this?

Thanks in advance,
Fantast~

 

[Fantast]

Hi,

I received the advise to create a Linked table in Access, which links to the SharePoint Document Library. There I should be able to see a field "Modified", and the documents should be attached in the table. I have however not been successful in creating such a Linked Table. Any advise would be greatly appreciated...

Best regards
Fantast~