Recently a collegue had to import a SharePoint list into Excel for automated processing.
Below you can find the source code that I provided him with as an example.
Sub LinkedSharePointList() ActiveSheet.ListObjects.Add SourceType:=xlSrcExternal, _ Source:=Array(<"URL String">, <"ListNameString">, _ <"{GUIDString}">), LinkSource:=True, Destination:=Range("A1") End Sub