Wondered if anyone has tried this before. Embarrasingly I have managed to do this years ago but now can't find a copy of how I did it !! Also was a much older version of SharePoint so maybe not the same now.
I am wanting to use VBA to download a View from a SharePoint list and populate an area on a Worksheet that already exists.
I have Googled but sadly the few examples I have found aren't working.
Access to the SharePoint site is via https.
Format to URL for the list is below (with soem xxx'sinstead of main name.
https://xxxx.sharepoint.com/sites/In.../AllItems.aspx
Many thanks
Mike
Bookmarks