From: Basta1980 on
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/company/css1/Lists/Historisch%20overzicht%20online%20diensten/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