Set objListObject

[Basta1980]

Hi all,

Rather frustrated here ;-)

Trying to import a list from Sharepoint but I can't get the syntax right.

Sharpoint Site =
https://sharepoint.mycompany.com/co...isch overzicht online diensten/Allitemsg.aspx
List = Overzicht Online diensten
Command = Set objListObject =
ActiveWorkbook.Worksheets(1).ListObjects.Add(SourceType:= xlSrcExternal, _
Source:= Array(strServerName, StrListGUID), TRUE, XlGuess,
Destination:= Range("A1")

How do I adress the source?

Kind regards

Basta1980