Set objListObject
 

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/com...Allitemsg.aspx
List = Overzicht Online diensten
Command = Set objListObject =
ActiveWorkbook.Worksheets(1).ListObjects.Add(Sourc eType:= xlSrcExternal, _
Source:= Array(strServerName, StrListGUID), TRUE, XlGuess,
Destination:= Range("A1")

How do I adress the source?

Kind regards

Basta1980